IF Statement Error - Help

[JodiG]

Hello,

Can you please help me?

If a value in a cell (J3) is greater than the previous 50 values (J4:J53) populate a cell (C3) with A. If not, populate C3 with B.

The formula I'm trying to use is:
=IF(J3>(MAX(J4:J54),"A","B"))

Does anyone know why this won't work?

Thanks,

JodiG

 

[VoG]

I think you have too many parentheses. Try

=IF(J3>MAX(J4:J54),"A","B")