Assistance with If then else Formula!

[SPEARSON1234]

Hi everyone,

Hopefully a simple answer from more experiences users. I am trying to put in a formula that looks at two cells and comes back with an answer. So if A2 is Greater than A1 then return yes, if A2 is less than A1 return No or return Equal if there is no difference between them.
I tried this but it is not working and I cannot work out what is wrong. Sorry for the relatively new user question!

=IF('PL PFA - DIS'!P5>'PL PFA - DIS'!P4)"Yes",IF('PL PFA - DIS'!P5<'PL PFA - DIS'!P4,"No","Maybe")

Thanks in advance for your help

 

[Peter_SSs]

Welcome to the MrExcel board!

Try

=IF('PL PFA - DIS'!P5>'PL PFA - DIS'!P4,"Yes",IF('PL PFA - DIS'!P5<'PL PFA - DIS'!P4,"No","Maybe"))

or you could also do it this way

=CHOOSE(SIGN('PL PFA - DIS'!P4-'PL PFA - DIS'!P5)+2,"Yes","Maybe","No")

 

[SPEARSON1234]

Welcome to the MrExcel board!

Try

=IF('PL PFA - DIS'!P5>'PL PFA - DIS'!P4,"Yes",IF('PL PFA - DIS'!P5<'PL PFA - DIS'!P4,"No","Maybe"))

or you could also do it this way

=CHOOSE(SIGN('PL PFA - DIS'!P4-'PL PFA - DIS'!P5)+2,"Yes","Maybe","No")

Thank you so much that is wonderful

 

[Peter_SSs]

You are welcome. Thanks for the follow-up.