ExcelBanter - If Condition Problem

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - If Condition Problem (https://www.excelbanter.com/excel-worksheet-functions/167959-if-condition-problem.html)

deen

If Condition Problem

Hi,

=IF(AND(B460<21),"NOT",IF(B421<60,"ELI"))

this formula not working,

i want result in A2 Not or ELI,

If thr is any possible do in macro pls let me abt the, bcoz new to the
macro.

Frederik[_3_]

If Condition Problem

Formula should be:

=IF(OR(B460,B4<21),"NOT","ELI")

greetz

"deen" schreef in bericht
...
Hi,

=IF(AND(B460<21),"NOT",IF(B421<60,"ELI"))

this formula not working,

i want result in A2 Not or ELI,

If thr is any possible do in macro pls let me abt the, bcoz new to the
macro.

All times are GMT +1. The time now is 01:15 AM.