View Full Version : [SOLVED:] Error Value
mdmackillop
03-03-2011, 07:50 AM
Why am I getting an error value in the yellow cells? (it's been a long day!)
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
03-03-2011, 09:20 AM
=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
03-04-2011, 05:58 AM
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).
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.