Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formula
I want to have an out come dependent upon values in two different columns.
The 1st column values will be either A, B, or C. The second Column will be a value 0-30. I want the result in the third column to be dependent upon what letter is in the first column and the value in second. The results will be Gold, Silver, Bronze, None. Any help in this would be appreciated, I lost my Excel for Idiots book. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formula
So what combination of your 1st and 2nd row values gives which outcome?
-- David Biddulph "WaltB" wrote in message ... I want to have an out come dependent upon values in two different columns. The 1st column values will be either A, B, or C. The second Column will be a value 0-30. I want the result in the third column to be dependent upon what letter is in the first column and the value in second. The results will be Gold, Silver, Bronze, None. Any help in this would be appreciated, I lost my Excel for Idiots book. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formula
if 1st is A and 2nd is 28-30=GOLD, 25.5-27.9=Silver, 23-24.4=Bronze, 23=None;
if 1st is B and 2nd is 26-30=GOLD, 22-25.9=Silver, 19-21.9=Bronze, 19=None; if 1st is C and 2nd is 27-30=GOLD, 24-26.9=Silver, 21-23.9=Bronze, 21=None "David Biddulph" wrote: So what combination of your 1st and 2nd row values gives which outcome? -- David Biddulph "WaltB" wrote in message ... I want to have an out come dependent upon values in two different columns. The 1st column values will be either A, B, or C. The second Column will be a value 0-30. I want the result in the third column to be dependent upon what letter is in the first column and the value in second. The results will be Gold, Silver, Bronze, None. Any help in this would be appreciated, I lost my Excel for Idiots book. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formula | Excel Worksheet Functions | |||
Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
Formula, Conditional Formula Needed | Excel Discussion (Misc queries) | |||
Conditional Formula to indicate Formula in cell | New Users to Excel | |||
conditional formula? | Excel Discussion (Misc queries) |