Associate
- Joined
- 31 Dec 2002
- Posts
- 458
Excel multi-condition logical test formula problem!!!!
Hi,
Please help me, I am going mad!!!!!!
In Excel I am trying to build a function to do the following in plain english:
If B2="Y" and C2="Y" and (D2+365)<today() then return True. This part works fine using the AND Function. However it only works if D2 has a date in.
D2 can also contain two other entries, either "NONE" or "NOT REQ". If it contains "NONE" then I want it also to evaluate to True and if it contains "NOT REQ" then I want it to evaluate to False.
At the moment the formula is:
AND(B2="Y",C2="Y",(D2+365)<today())
Really I want to check for "NONE" and "NOT REQ" before processing the above.
Thanks. hope it makes sense.
Hi,
Please help me, I am going mad!!!!!!
In Excel I am trying to build a function to do the following in plain english:
If B2="Y" and C2="Y" and (D2+365)<today() then return True. This part works fine using the AND Function. However it only works if D2 has a date in.
D2 can also contain two other entries, either "NONE" or "NOT REQ". If it contains "NONE" then I want it also to evaluate to True and if it contains "NOT REQ" then I want it to evaluate to False.
At the moment the formula is:
AND(B2="Y",C2="Y",(D2+365)<today())
Really I want to check for "NONE" and "NOT REQ" before processing the above.
Thanks. hope it makes sense.
Last edited:
