ExcelBanter - If statement

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - If statement (https://www.excelbanter.com/excel-discussion-misc-queries/23202-if-statement.html)

FGM

If statement

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

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

Biff

Hi!

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

Biff

"FGM" wrote in message
...
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

All times are GMT +1. The time now is 09:13 PM.