#VALUE!....MAKE IT GO AWAY!

[jonnykats]

ok so all my formulas are correct but this "#VALUE!" shows in the cells where no data has been selected or inputed.. is there a way to "hide" the error code? its saying theres an error cause there is no data for the formula to calculate.. help anyone?

 

[NBVC]

you can change your formula to allow for error handling.

e.g

=If(cell_ref="","",your_formula)

replacing the italicized parts with your info.

 

[jonnykats]

so would it look like this: =If(cell_ref="","",(b6*l6)

 

[NBVC]

You need to replace the "cell_ref" with an actual cell reference, Like B6 (if that's the one to check if any input has been done).

e.g.

=IF(B6="","",B6*I6)

but is it B6 or I6 giving you the problem, because B6*I6 should give 0 if any are blank....unless you have a true space, then it will give #Value

if that is the case, use

=IF(TRIM(B6)="","",B6*I6))


if you need to check both B6&I6, then

=IF(OR(TRIM(B6)="",TRIM(I6)=""),"",B6*I6))

 

[jonnykats]

YOUR AWSOME! THNAKS!
it worked perfectly!!

 

[big_mac]

makes thing a little longer but how about

=if(iserror(B6*I6),"",B6*I6)

 

[jonnykats]

i spoke to soon!! ok so now the error is gone but once the data is there to calculate, the feild stays blank or $ -

 

[NBVC]

If B6*I6 on it's own works, then so should the formula when both fields are occupied with a value.

 

[jonnykats]

my dumb mistake, i hade a "I" when it should of been an "L" hey another question.
how can i protect certain coloums?