Hello. I have to make a formula with a nested if function using either a date given in the cell or today's date if a cell is blank.
=IF(B5<>"",IF(B5-A5<=14,"Fast",IF(B5<>"",IF(B5-A5<=45,"Regular",IF(B5<>"",IF(B5-A5<=90,"Slow",IF(B5<>"",IF(B5-A5>91,"Problem"),IF(TODAY()-A5<=15,"Fast",IF(TODAY()-A5<=45,"Average",IF(TODAY()-A5<=90,"Slow",IF(TODAY()-A5>91,"Problem")))))))))))
In cell b is either a blank cell or the given date. In cell A is the date it was made.
I cannot figure out the problem in the formula, however, as it is coming up false for the days which cell B was blank when it should be using today's date.
Any help would be appreciated. Thank you.
Bookmarks