IF Formula

[howardjo]

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

[stevekirk]

hi

try

=IF(H15="Yes",(F15-E15)/E15," ")

steve

[howardjo]

Nope,

Still doesn't calculate the formula.

What I am ultimately trying to do is hide and error, when one occurs.

The other thing I have tried to do is a conditional format that changes the colour of the text in the cell G15 to white, when cell H15="True".

I have written =$H15="TRUE" into the conditional format, but this also doesn't work.

Regards

[stevekirk]

hi,

cannot understand why it does not work see attached file
and conditonal g15

let me know if it is not correct

[howardjo]

Thank you.

I don't know why it wasn't working, but I have deleted it, and re-typed it, and it seems to be sorted now.

Regards

Howardjo

[howardjo]

Thank you.

I don't know why it wasn't working, but I have deleted it, and re-typed it, and it seems to be sorted now.

Regards

Howardjo