RWayneH

asked on

# Help with Nested if formula

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?

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?

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

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

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

ASKER

Thanks for the help