Excel2010 IF Formula to return value based on a separate date and two separate text values

1. Excel2010 IF Formula to return value based on a separate date and two separate text values

Hi,

I am trying to get a cell (X9) to return either

a date thats +14days from another cells (V9) date if another cell (W9) has "yes" value
a blank cell if another cell (V9) is blank
an "N/A" if another cell (W9) has a "No" Value

Ive tried this but to no good:

=IF(V9="","",V9+14),IF(AND(V9=>01/01/1986,W9="Yes"),V9+14,IF(W9="No","N/A")

Any help would be much appreciated

Thanks

Jake

2. Re: Excel2010 IF Formula to return value based on a separate date and two separate text va

May be this...?

=IF(V9="","",IF(AND(V9>=DATE(1986,1,1),W9="Yes"),V9+14,IF(W9="No","N/A","")))

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1