Using IF in conjunction with AND in nested formula

[halefamily104]

Hello Again,

I am trying to calculate two different number of days to a certain date. There are three nested formulas:

=IF(AND(D16="Apples",FL16+365),IF(AND(D16="Bananas",FL16+365),IF(AND(D16="Oranges",FL16+90),"")))

So basically:
If D16 is Apples then you will add 365 days to the date in FL16
If D16 is Bananas, add 365 to FL16
If D16 is Oranges, add 90 days to FL16.

The formula above returning FALSE instead of the calculated date. Any ideas?


Thanks

 

[Eric W]

Try:

=FL16+IF(OR(D16={"Apples","Bananas"}),365,90)

 

[halefamily104]

THIS FORUM IS FANTASTIC!??

Yes, that did it!

Thanks so much!

Until next time!

 

[Eric W]

Happy to help!

 

[jtakw]

Hi,

Or, you can reverse the logic and make it a bit shorter:

=FL16+IF(D16="Oranges",90,365)