If statement

[FGM]

Windows 2000 / Excel 2002

Can if statement in Excel use and??

=IF(G40 > N5 and G40 < N4,"OKay","NO")

Do I have to do a nested to get this?

Thank you

 

[Guest]

use
IF(and(G40 > N5, G40 < N4),"OKay","NO")

 

[Biff]

Hi!

=IF(AND(G40>N5,G40<N4),"OK","NO")

Biff