Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditonal Formula
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?? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditonal Formula
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?? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditonal Formula
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 "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?? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditonal Formula
hi,
=if(left(a12,2)="WE",f12+170,f12+14) hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "flyers5182" escreveu: 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?? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditonal Formula
Thanks, that seemed to work. Should I include "undefined" in every
subsequent condition, or just @ the last condition? "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?? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditonal Formula
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?? |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditonal Formula
=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?? |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditonal Formula
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 "flyers5182" wrote in message ... Thanks, that seemed to work. Should I include "undefined" in every subsequent condition, or just @ the last condition? "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?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find value in array | Excel Worksheet Functions | |||
Reusing formula | Excel Discussion (Misc queries) | |||
How do I do Conditonal Formatting with formula progression | Excel Worksheet Functions | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions |