Help with Nested if formula

RWayneH
RWayneH used Ask the Experts™
on
I have a need to place a formula in a cell that does the following in row 2:

If K2 is less than TODAY  answer "Past Due"
If K2 is greater than or equal to TODAY    answer "Future"
If K2 is "" look at H2,  if H2 is blank  answer "Future"
If K2 is "" look at H2,  if H2 is < TODAY  answer "Past Due"
If K2 is "" look at H2,  if H2 is > or equal to TODAY   answer  "Future"

This type of formula is beyond me... and I am not sure if I can get this all into one nested if?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
By TODAY do you mean today's date or do you mean the string "TODAY"?
Try

=IF(K2="",IF(OR(H2="",H2>=TODAY()),"Future","Past due"),IF(K2<TODAY(),"Past due","Future"))

Author

Commented:
let me test this before I close it..  Thanks.

Author

Commented:
Thanks for the help

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial