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.
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
