Formula using "if cell is blank"

[Richard Pitt]

I need help with the following formula:

I am in "Cell I6" and I want the following calculation:
If G6 is blank, then blank, else I5 minus G6 plus H

 

[Don Guillett]

multi posting is a no no

 

[GJB]

Try this :

=if(g6="","",I5+G6+H6)

 

[BenjieLop]

GJB,

Your formula should be modified to


=IF(G6=\"\",\"\",I5*-*G6+H6


to satisfy the conditions stated.

Try this :

=if(g6="","",I5+G6+H6)

 

[Alan]

That formula doesn't work on the English version of Excel, what version are
you using?