How to Change the operator in formula from drop-down in Excel

Mar 8, 2010 11:35 AM
Article cover image

In this Excel magic trick video the tutor shows how to change operator in a formula from a drop down using Choose function. He shows a basic work book which can be downloaded from the internet for hands-on to the tutorial. In this trick the tutor shows how to include some operators in a drop down box of a cell and based on this drop down value change the operators in equations that are using this cell there by dynamically altering the equation and the value produced using the equation. For this he uses a data validation operation where he includes all the valid values as a list and now he shows how to change it dynamically using the Choose function. This video shows how to change operator in a formula by choosing a value from a drop down box using the Choose function in Microsoft Excel.

Just updated your iPhone? You'll find updated Apple Intelligence capabilities, new wallpapers, and enhancements to Calculator, PDF cropping, and Live Voicemail, among other useful features. Find out what's new and changed on your iPhone with the iOS 18.3 update.

Related Articles

Comments

No Comments Exist

Be the first, drop a comment!