=IF(OR(A12="WE",A12="AE",A12="CP"),F12+170,IF(...
--
David Biddulph

"flyers5182" wrote in message
...
Also, if I have multiple initals with the same condition, Like WE, AE,
etc.
all use 170 days, is there a way to do that? like if A12="WE""AE""CP", of
"WE"or"AE"or"CP"...?

"David Biddulph" wrote:

To correct the part you've got already, try
=IF(A12="WE",F12+170,IF(A12="OA",F12+140,"undefine d"))

If you have 10 sets of initials, try a LOOKUP formula, as IF will cope
with
only 7 layers of nesting.
--
David Biddulph

"flyers5182" wrote in message
...
I need the correct conditional formula for the following example:

If the A column is (a personal initials e.g. WE), I want Column G to
equal
Column F+170. If column A is different initails (e.g. OA), I need
Column
G
to equal Column F+140. The F Column is calender days (e.g. 3/10/07). I
have
searched the help topics and tried to emulate formulas from previous
similar
questions, but to no avail. Any tips would be great. The current
formula
I
have is (in cell G12):
=IF(A12=WE,F12+[170],IF(A12=OA,F12+[140]))

There are several conditions (10 initials total) What am I doing
wrong??