Greater than and conditions doesnt seem to work

Hi everyone,

Apologies in advance if this is a silly question, but i cant seem to get this IF statement to work.

Example
I have 4 columns, A-D presented below:

A B C D
-30 , -30, 0, 10

i would like to replace replace the numbers with words via a IF statement.

for example on column B:
If column B is greater than Column A than return "Improvement"
but if
If column B is greater than Column A and is greater than "0" then return "Recovered"
but if
Column B is equal to Column A then return "No Change"

Is this possible to generate into a IFstatment/ formula please?

Thanks in advance everyone

CT

Assume values are in A2 and B2, this in C2:

=IF(AND(B2>A2,B2>0),"Recovered",IF(B2>A2,"improvement",IF(B2=A2,"No change","Not defined in the formula?!")))

(Last bit is because you haven't said what you want if Col B is less than Col A?)


Ochimus

=IF(B1=A1,"No Change",IF(B1>A1,IF(B1>0,"Recovered","Improvement"),"ABANDON ALL HOPE!"))

If col A is also greater than 0, would you still want these results?

Originally Posted by Ochimus

Assume values are in A2 and B2, this in C2:

=IF(AND(B2>A2,B2>0),"Recovered",IF(B2>A2,"improvement",IF(B2=A2,"No change","Not defined in the formula?!")))

(Last bit is because you haven't said what you want if Col B is less than Col A?)


Ochimus

Hi Ochimus,
Thank you for your formula and prompt response.
apologies my mistake, if column b is less than column A please return with "monitor closely".

Thanks again in advance😊

CT

Originally Posted by hrlngrv

=IF(B1=A1,"No Change",IF(B1>A1,IF(B1>0,"Recovered","Improvement"),"ABANDON ALL HOPE!"))

If col A is also greater than 0, would you still want these results?

Hi hrlngrv,

Thank you very much.

The formula works perfectly.

Kind regards,

CT