Posted 19 August 2010 - 10:57 AM
I have cells where the formulas are the same, but the first in the series is coming up with a "#VALUE" error that I can't figure out. The second one creates a "#VALUE" error, presumably because I have the first error sitting above it.
It disappears when you put a value in in the user input value, and gives you a correct solution, but I'd prefer not to see the errors at all, but a blank cell instead.
CELL K15: <user input value>
CELL K16: <user input value>
CELL K17: <user input value>
CELL G21: <user input value> -- CELL I21: <.5, currency format> -- CELL K21: =IF(G21>0,(G21*I21),"")
CELL G22: <user input value> -- CELL I22: <.5, currency format> -- CELL K22: =IF(G22>0,(G22*I22),"")
CELL G23: <user input value> -- CELL I23: <.5, currency format> -- CELL K23: =IF(G23>0,(G23*I23),"")
CELL K25: =SUM(K15:K17,K21:K23)
I don't know how to write complex formulas, and these are someone else's, so I'm not sure what I'm looking at with the =IF statement up there.
What do I need to do, so K21 remains blank until I enter a value in G21? I'm working on the conclusion that once that goes away, I won't see the same error in K25.