Error Value

[mdmackillop]

Why am I getting an error value in the yellow cells? (it's been a long day!)

[GTO]

Sigh... Third try (server busy)

I do not know why, but =E9=0 returns #VALUE! if E9 currently returns the same.

Hope that helps :-)

Mark

[Tommy]

=IF(OR(ISERROR(E10),E10=0),F10,E10)

The E10=0 is returned when there is an error it is not setting the value of E10 to 0.

just as a guess:=IF(ISERROR(E10),F10,E10)

[shrivallabha]

Perhaps this is what you are after (I hope I am not sounding flippant) if I have understood it correctly. Then the formula in E9 needs to be corrected:

=IF(ISERROR((C9/1000)/D9),0,(C9/1000)/D9)
I suppose it will not be possible to change from Cell G9 formula to "0".
And the in G9 condition will change to:

=IF(E9=0,F9,E9)

I am just trying to help as you have been a great help always. Sorry if I have added to the confusion.

I am attaching the Excel Sheet (Only E9 and G9 formula changed).