If/Then Statement
Thank you VERY much for your help.
"bj" wrote:
in U1
=if(or(F1=1,F1=2,F1=3),N1+16,if(or(F1=4,F1=5),"N/A","otherwise"))
if f1 can only be 1-5 then
=if(f1<=3,N1+16,"N/A")
if you want the N/A error then replace "N/A" with NA()
"Karen" wrote:
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
|