Solved IF Formula with drop down

January 21, 2013 at 10:46:57
Specs: Windows 7
I am trying to creat a formula for a excel spread sheet. I want the if formula to say if cell h6 is yes then subtract cell j6-e6. I have a drop down that lets you select yes or no.

See More: IF Formula with drop down

Report •

January 21, 2013 at 12:15:38
✔ Best Answer
The simple answer is


this assumes that if h6 is anything other than "Yes" then the cell will remain blank.

Give this a try and let us know how it works out for you

Report •
Related Solutions

Ask Question