IF function help on a simple formula

Question

Hi there, i am looking for help on a very basic formula:

Cell C1 = If cell A1 and/or cell B1 is blank, then return blank, otherwise return the result of Cell B minus Cell A.

I have tried multiple options but don't get the preferred answer.

tian77 · Answer

Great, thanks Twifoo, this works ! Much appreciated

sergeibaklan · Answer

Tian77&nbsp;
It could be
=IF((LEN(A1)+LEN(B1))*LEN(B1),B1-A1,"")

tian77 · Answer

Hi Sergei, i copied your formula, however am still getting a error: "not trying to type a formula" , excel thinks i am trying to type a statement.

sergeibaklan · Answer

Tian77&nbsp;
Please check the formula in attached file

twifoo · Answer

Tian77&nbsp;Try this:&nbsp;=IF((A1="")+(B1=""),"",B1-A1)

Forum Discussion