Make result "#VALUE! Clear

R

rockon

i have some cells that return #VALUE!. when the right info gets put in
everything works fine. what i am looking for is in the mean time... until i
put in the info... for it to not show #VALUE!. i have tried conditional
formatting but i can't seem to get it to work. anybody know what can be done?
 
L

lsu-i-like

what i do in those situations is use an if statement.

lets say in cell a1 i have the number 5. in cell a2 i havent anything
in cell a3 i would put this =if(a2="","",if(a1="","",a2/a1))

this checks a2 first. if a2 is blank ("" is a way to refer to a blan
cell) then cell a3="". if a2 isnt blank it checks a1. if neither i
blank it divides a2 by a1
 
D

Dave Peterson

I'd change the formula:

=if(iserror(yourformula),"",yourformula)

but I used this formula in my conditional formatting formula:

=ISERROR(A1)

And made it white on white (same font color as fill color)
 
L

lsu-i-like

dave peterson, does that work for other errors such as DIV/0? thats
pretty cool, and i didnt think about the white font on the white
background. you rock. i didnt know about the iserror function.
things like this get me so excited. =)
 
D

Dave Peterson

What happened when you tried it? <vbg>.

(quietly... It worked for all the errors I tried.)
 
L

lsu-i-like

lol, i actually havent used it yet. i do have many instances to use it
but ive been busy doing non-computer work the past few days. :
 
Top