Link to home
Start Free TrialLog in
Avatar of RWayneH
RWayneHFlag for United States of America

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?
Avatar of Martin Liss
Martin Liss
Flag of United States of America image

By TODAY do you mean today's date or do you mean the string "TODAY"?
ASKER CERTIFIED SOLUTION
Avatar of Saqib Husain
Saqib Husain
Flag of Pakistan image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of RWayneH

ASKER

let me test this before I close it..  Thanks.
Avatar of RWayneH

ASKER

Thanks for the help