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


"FGM" wrote:

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