IF function with 3 condition

Hello All,

I would like to use if formula to set up with 3 conditions but i'm always getting conflict.

Anyone, please help me.

condition i want to use in attached excel file.
if Aging less than 28days there is no reminder
* Reminder I: in between 28-41days
* Reminder II: in between 42-59days
* reminder III: start from 60days on ward

Thanks,
leakhna

Here's one way. In E4;

Formula:

Please Login or Register  to view this content.

And copy down.

Here you go:
=IF(C4<28,"",IF(AND(C4>=28,C4<=41),"R1",IF(AND(C4>=42,C4<=59),"R2",IF(C4>=60,"R3",""))))

Hi,

Thanks for the formula it works but I just found that there one is different from another brand as as below:

==> if it names "Baby" then whenever the age over than 21days it will be as an "alert".

Just add another condition. You should check the nested ifs

=IF(AND(B4="Baby",C4>=21),"Baby/Alert",IF(C4<28,"",IF(AND(C4>=28,C4<42),"Reminder I",IF(AND(C4>=42,C4<60),"Reminder II","Reminder III"))))

As the formula evaluates the conditions in order AND(C4>=28,C4<42) is the same as c4<42, so the formula can be reduced

=IF(AND(B4="Baby",C4>=21),"Baby/Alert",IF(C4<28,"",IF(C4<42,"Reminder I",IF(C4<60,"Reminder II","Reminder III"))))

Hi,

Here's another way.

In your description, you say for Baby, "older than 21 days", yet your sample shows "Alert" for 21 days, so remove the "equal" part in red if necessary:

=IF(AND(B4="Baby",C4>=21),"Alert",LOOKUP(C4,{0,28,42,60},{"","Reminder I","Reminder II","Reminder III"}))

See attached.

Big thanks.

Hi,

Late to the party (different time zone), I don't understand the use of all the ANDs, here's a simplified version of the Nested IF:

Formula:

Please Login or Register  to view this content.

And here's my LOOKUP suggestion:

Formula:

Please Login or Register  to view this content.

See attached for Both samples.