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.

only want formula to show up if a1 is not blank
 

Try

=IF(I2="","",I2*0.024+0.2)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"ouch" wrote in message
oups.com...
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.

only want formula to show up if a1 is not blank
 

=IF(I2="","",I2*0.024+0.2)


Gord Dibben MS Excel MVP

On 25 Jun 2006 10:04:52 -0700, "ouch" wrote:

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.

only want formula to show up if a1 is not blank
 

=IF(A1="","",IF(I2="","",I2*0.024+0.2))

Vaya con Dios,
Chuck, CABGx3



"ouch" wrote in message
oups.com...
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.