if cell > 0

[Trevor3007]

hi,

Any one have the formula so if a cell > 0, then that cell -30 but if that cell is empty dont display anything?

I know if I used =if(a1>0,a1,"") that works, but when I add the -30 it either displays -30 or #value

can someone sort me out?

KR
Trevor3007

 

[t0azt]

=if(a1>0,a1-30,"")

 

[Trevor3007]

=if(a1>0,a1-30,"")

thank you t0azt,

now that I have seen your answer , its a big DOH on me!!!!

thank you very much & hope you have a good xmas.

KR
Trevor3007