Using IF Function reporting on two Cells and not quite happening!! HELP...

Hi,

Any help is appreciated. I've attached images below.

What I trying to achieve is;
If the QUOTE COLUMN is empty I wish the variance column to return a message ENTER/REQ. QUOTE The formula I’m using for this is =IF(K43=0,"ENTER/REQ. QUOTE",(M43/K43)-1)

However if I enter a value into the quote column and the ACTUAL COLUMN remains empty I get a weird % figure. However I would like this column to report a message or 0%.

In summary I wish for the formulas to evaluate both the QUOTE and ACTUAL columns and report 0 or possibly a message.

Any help is greatly appreciated.

Many thanks.

please attach a excel sheet...

Hi Amigo,

If I consider your "summary" you can use this formula

=IF(AND(A2="",B2=""),"ENTER/REQ, QUOTE", "0") (which write either 0 or a message, but the calculation "(M43/K43)-1" will not work)

-Nanju

Thanks sktneer,

Is it possible though to report a different message for each cell that has a value of 0 i.e if a value is entered into the quote column (k) and the actual column (m) remains at 0 a different message is displayed?

Fantastic sktneer, spot on.