Morning
I am trying to write an IF formula that states:
IF H15="Yes" then (F15-E15)/E15, If not, then " ".
The formula I wrote was:
=IF(H15="Yes","=(F15-E15)/E15"," ")
However, Excel will not let me use the middle bit of this formula, without putting speach marks arround it. But, this is then recognised as text, so the result is only shown as: "=(F15-E15)/E15" not the result of the formula.
Regards
Howardjo
Bookmarks