Formula using "if cell is blank"

Richard Pitt · Oct 15, 2004

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 · Oct 15, 2004

multi posting is a no no

GJB · Oct 17, 2004

Try this :

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

BenjieLop · Oct 17, 2004

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 · Oct 17, 2004

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