Thread: only want formula to show up if a1 is not blank
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ouch
 
Posts: n/a
Default only want formula to show up if a1 is not blank
Hi
I have this formula in excel:

=I2*0.024+0.2

which gives me 2.4% plus 0.20 of column i2
But if i2 is blank -0.20 shows up but I dont want it to show up if i2
is blank.

Reply With QuoteReply With Quote