value expression
=if(e9<0,0,e9*50+10)
Does your formula REALLY have the 10 in quotes? Get rid of them.
"RayB" wrote:
I have a formula that states =(e9*50)+"10"
I'd like to make this formula conditional where it only does calculates the
formula if e9 0
so.. how do you do a simple "if" statement please?
( if e9<0 then F9=0 else F9 = (e9*50)+10 ) is what I'm trying to accomplish.
Thanks!
RayB.
|