Using an IF statement in Excel

Guest2

Guest2

Guest2

Soldato
Joined
6 May 2009
Posts
20,361
I have this formula in excel

=((C5+E5+G5)-(B5+D5+F5))/(B5+D5+F5)

When I use the autofill it populates the column with

=((C6+E6+G6)-(B6+D6+F6))/(B6+D6+F6) 7,8,9 etc correctly


How would I go about using an IF statement to make it not show -100.00% in the cells in the column? -100.00% is a value that is worked out when no figures are entered into C5, E5 etc. When figures are present it changes.

I would like the cells to simply populate with the formula but not show any number until figures are entered.

Im not great with excel or maths in general unfortunately



Thanks
 
IF(C5<>"", ((C5+E5+G5)-(B5+D5+F5))/(B5+D5+F5), "")

This says: If C5 is NotEqual to Blank, then apply Formula, Otherwise keep cell Blank

You should be able to expand this to do what you want.
 
You must log in or register to reply here.
Back
Top Bottom