Excel formula - TechRepublic
General discussion
October 5, 2005 at 06:54 AM
hduff

Excel formula

by hduff . Updated 17 years ago

I am trying to write an “if blank” formula in Excel

I have the following formula working –
=if(blank(D6),0,E5+D6)

this checks D6 and if blank, enters 0. If not blank, E5 is added to D6.

I need to check that D6 and C6 are both blank.

Any suggestions.

Thanks

This discussion is locked

All Comments