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 •


#1
January 21, 2013 at 12:15:38
✔ Best Answer

Hi
The simple answer is

=IF(H6="Yes",j6-e6,"")

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