ExcelBanter - IF ... and... HELP ... :)

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - IF ... and... HELP ... :) (https://www.excelbanter.com/excel-programming/342453-if-help.html)

Darin Kramer

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

Whats wrong with my formulae..

=IF(AND(AI22=1,(P2220%),"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

*** Sent via Developersdex http://www.developersdex.com ***

Shatin[_2_]

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

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

=IF(AND(AI22=1,(P2220%)),"D","-")

"Darin Kramer" wrote in message
...

Whats wrong with my formulae..

=IF(AND(AI22=1,(P2220%),"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

*** Sent via Developersdex http://www.developersdex.com ***

Tom Ogilvy

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

=IF(AND(AI22=1,P2220%),"D","-")

--
Regards,
Tom Ogilvy

"Darin Kramer" wrote in message
...

Whats wrong with my formulae..

=IF(AND(AI22=1,(P2220%),"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

*** Sent via Developersdex http://www.developersdex.com ***

All times are GMT +1. The time now is 11:08 PM.