View Single Post
  #3   Report Post  
Peo Sjoblom
 
Posts: n/a
Default only use formula if than 0

No need for sum here

=IF(A1="","",A1*3.4%+0.2)


--

Regards,

Peo Sjoblom

"owlie" wrote in message
...
Hi, I want to create a formula that only works if I have a figure in a

cell

eg.,

A1 1.70
B1 =sum(a1*3.4%)+0.20

But if A1 was blank, I don't want any figure in B1.

Thanks for any help