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