Thank you VERY much for your help.

"Leo Rod" wrote:

Assuming N1 as a date

On cell U1 write:
=if(or(f1=1,f1=2,f1=3),n1+16,if(or(f1=4,f1=5),"N/A","not defined"))

This will work as requested and will write "not defined" for values
different than 1,2,3,4,5.

Let me know how it works.

Greetings

Leo.

"Karen" wrote in message
...
I need help with an IF/THEN statement if anyone can be so kind.
The formula will be placed in column U.

In column F there could be a number 1, 2, 3, 4 or 5.
In column N will be a date.

This is the scenario:
If cell F1 has a 1, 2 or 3, then cell U1 equals N1 + 16 days.
If cell F1 has a 4 or 5, then I want an N/A in cell U1.

ANY help would be greatly appreciated, Karen