Combine Nested Funtions

[gleichmang]

Need help combing these function into a single cell

This formula recalculates the date based off a value in column P
=IF(OR(P16="A - Svcbl(w/o Qual)",P16=""),(AM16+450),(AM16+90))

This formula determines the amount of days between today and the new date
=ABS(AN16-TODAY())

This formula enters a value based on the above calculation
=IF(AO16<90,"CURRENT","OVERDUE")

How can I combine these into a single cell in column AN?

 

[Fluff]

How about
=IF(ABS(IF(OR(P16="A - Svcbl(w/o Qual)",P16=""),(AM16+450),(AM16+90))-TODAY())<90,"Current","Overdue")

 

[gleichmang]

Worked like a champ.... So easy, cant believe I didn't see that

 

[Fluff]

You're welcome & thanks for the feedback

 

[gleichmang]

Something is still a tad off

The 'Overdue' and 'Current' don't seem to be calculating correctly... The second entry is not calculating right, where am I going wrong...

=IF(ABS(IF(OR(A3="A - Svcbl(w/o Qual)",A3=""),(B3+450),(C3+90))-TODAY())>90,"Current","Overdue")

<tbody> [TD="width: 164, bgcolor: transparent"] Cond Cd [/TD]
[TD="width: 104, bgcolor: transparent"] Last Insp Dt [/TD]
[TD="width: 104, bgcolor: transparent"] Next Insp Dt [/TD]
[TD="width: 115, bgcolor: transparent"] Inspection Status [/TD]
[TD="width: 164, bgcolor: transparent"] TEST [/TD]
[TD="width: 104, bgcolor: transparent"] 10/24/2019 0:00 [/TD]
[TD="width: 104, bgcolor: transparent"] 10/23/2018 0:00 [/TD]
[TD="width: 115, bgcolor: transparent"] Overdue [/TD]
[TD="width: 164, bgcolor: transparent"] A - Svcbl(w/o Qual) [/TD]
[TD="width: 104, bgcolor: transparent"] 10/24/2013 0:00 [/TD]
[TD="width: 104, bgcolor: transparent"] 10/23/2020 0:00 [/TD]
[TD="width: 115, bgcolor: transparent"] Current [/TD]
</tbody>

 

[gleichmang]

Incorrect Calculation

Where am I going wrong....

The 'Overdue' and 'Current' don't seem to be calculating correctly... The second entry in the below table is not calculating right,

=IF(ABS(IF(OR(A3="A - Svcbl(w/o Qual)",A3=""),(B3+450),(C3+90))-TODAY())>90,"Current","Overdue")

[TABLE="class: cms_table"]
<tbody>[TR]
[TD="width: 164, bgcolor: transparent"]Cond Cd[/TD]
[TD="width: 104, bgcolor: transparent"]Last Insp Dt[/TD]
[TD="width: 104, bgcolor: transparent"]Next Insp Dt[/TD]
[TD="width: 115, bgcolor: transparent"]Inspection Status[/TD]
[/TR]
[TR]
[TD="width: 164, bgcolor: transparent"]TEST[/TD]
[TD="width: 104, bgcolor: transparent"]10/24/2019 0:00[/TD]
[TD="width: 104, bgcolor: transparent"]10/23/2018 0:00[/TD]
[TD="width: 115, bgcolor: transparent"]Overdue[/TD]
[/TR]
[TR]
[TD="width: 164, bgcolor: transparent"]A - Svcbl(w/o Qual)[/TD]
[TD="width: 104, bgcolor: transparent"]10/24/2013 0:00[/TD]
[TD="width: 104, bgcolor: transparent"]10/23/2020 0:00[/TD]
[TD="width: 115, bgcolor: transparent"]Current[/TD]
[/TR]
</tbody>[/TABLE]


Bottom line... based off the above, my value in 'Inspection Status' column for the second row should read 'overdue' not current. Cant figure out where I am off... Please help

 

[Yongle]

Re: Incorrect Calculation

Not offering any help, just observing that I am puzzled that inspection due in Oct 2020 should be classified as overdue in Oct 2019

 

[RoryA]

Re: Incorrect Calculation

If you add 450 days to B3 you get 17 Jan 2015. The difference between that and today is more than 90 days, so you get Current.

 

[Joe4]

Re: Incorrect Calculation

I have merged your two threads together.

In the future, please do not post the same question multiple times in different threads. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will typically be locked or deleted (rule 12 here: Forum Rules).