Yandeez Member Feb 19, 2015 #1 I have a simple example attached. When the formula returns false, I need it to return 150%. Any help is greatly appreciated. Attachments Chandoo if example.xlsx 7.6 KB · Views: 6
I have a simple example attached. When the formula returns false, I need it to return 150%. Any help is greatly appreciated.
Smallman Excel Ninja Feb 19, 2015 #2 Hi Yandeez This should do it. =IF(F10=E10,"Yes",1.5) Format the cell as a % Take care Smallman