3 Way Response IF statement

[Ben171]

Hi all,

I have the following simple if statement which says if the number in G is bigger than in F, return "Overpaying" and if less than F return Underpaying.

I want to add a third statement to this, to return "Neither" if the value in G is the same as F

=IF(G1978>C1978,"OVERPAYING","UNDERPAYING")

 

[Joe4]

Just nest an IF statement, i.e.

=IF(G1978=C1978,"Neither",IF(G1978>C1978,"OVERPAYING","UNDERPAYING"))

Note: You say you are comparing column G to column F, but you formula is comparing column G to column C.
I am not sure which one you actually mean, so adjust the formula accordingly, if necessary.

 

[Ben171]

Just nest an IF statement, i.e.

=IF(G1978=C1978,"Neither",IF(G1978>C1978,"OVERPAYING","UNDERPAYING"))

Note: You say you are comparing column G to column F, but you formula is comparing column G to column C.
I am not sure which one you actually mean, so adjust the formula accordingly, if necessary.

whoops sorry! was in a rush to write this up before lunch in hope I would get a reponse by the time i come back.

Thank you for your help that worked perfectly! Need to get the hang of these nested IF's.

Thanks