IF ... and... HELP ... :)

[Darin Kramer]

Whats wrong with my formulae..

=IF(AND(AI22=1,(P22>20%),"D","-"))

I want it to say if AI22 = 1 and if p22 is greater than 20% then put a
D, if not put a -.

Where am i going wrogn... Thanks...

D

 

[Shatin]

There's a ) missing after 20%. Formula should be:

=IF(AND(AI22=1,(P22>20%)),"D","-")

 

[Tom Ogilvy]

=IF(AND(AI22=1,P22>20%),"D","-")