Conditonal Formula

[Guest]

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??

 

[David Biddulph]

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

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

 

[T. Valko]

There are several conditions (10 initials total)

What am I doing wrong??

If you have 10 possible conditions then you should create a 2 column table
like this:

...........J...........K
1.....WE........170
2.....OA........140
3.....XX........150
4.....YY........100

Then use a lookup formula like this:

=IF(A12="","",F12+VLOOKUP(A12,J1:K4,2,0))

Biff

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??

 

[Guest]

hi,

=if(left(a12,2)="WE",f12+170,f12+14)

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"flyers5182" escreveu:

 

[Guest]

Thanks, that seemed to work. Should I include "undefined" in every
subsequent condition, or just @ the last condition?

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

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

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??

 

[Guest]

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"...?

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

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

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??

 

[David Biddulph]

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

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"...?

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

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

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??

 

[David Biddulph]

I'd just included the "undefined" to cope with where the A12 input doesn't
meet any of your conditions, so it's only needed as an alternative from the
final condition. You can leave it out, if you wish, but in that case the
formula will return the result 'FALSE' if none of the preceding conditions
are fulfilled.
--
David Biddulph

Thanks, that seemed to work. Should I include "undefined" in every
subsequent condition, or just @ the last condition?

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

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

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??