Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formula
Hello,
I want to make all the conditions occur in cell b1: if cell a1 = 1 then cell b = 7 if cell a1 = 2 then cell b = 6 if cell a1 = 3 then cell b = 5 if cell a1 = 4 then cell b = 4 I know how to do =IF(G2=1,"7") but I can't figure out how to add the rest of the conditions to it so they are all in cell b1. I've tried a dozen different combinations of commas, brackets, colons, etc. and searching "help" isn't helpful! How do I combine all these conditions? Thank you. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formula
Sorry, I meant to say b1 for all the conditions where b occurs. So for
example, if cell a1 = 1 then cell b1 = 7 Thank you "RichM" wrote: Hello, I want to make all the conditions occur in cell b1: if cell a1 = 1 then cell b = 7 if cell a1 = 2 then cell b = 6 if cell a1 = 3 then cell b = 5 if cell a1 = 4 then cell b = 4 I know how to do =IF(G2=1,"7") but I can't figure out how to add the rest of the conditions to it so they are all in cell b1. I've tried a dozen different combinations of commas, brackets, colons, etc. and searching "help" isn't helpful! How do I combine all these conditions? Thank you. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formula
If the sequence continues, perhaps...
= 8-A1 = = = = = = HTH :) Dana DeLouis On 5/29/10 12:41 PM, RichM wrote: Hello, I want to make all the conditions occur in cell b1: if cell a1 = 1 then cell b = 7 if cell a1 = 2 then cell b = 6 if cell a1 = 3 then cell b = 5 if cell a1 = 4 then cell b = 4 I know how to do =IF(G2=1,"7") but I can't figure out how to add the rest of the conditions to it so they are all in cell b1. I've tried a dozen different combinations of commas, brackets, colons, etc. and searching "help" isn't helpful! How do I combine all these conditions? Thank you. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formula
Thank you.I figured it out. I now have another question related to this
posted in another thread. "RichM" wrote: Hello, I want to make all the conditions occur in cell b1: if cell a1 = 1 then cell b = 7 if cell a1 = 2 then cell b = 6 if cell a1 = 3 then cell b = 5 if cell a1 = 4 then cell b = 4 I know how to do =IF(G2=1,"7") but I can't figure out how to add the rest of the conditions to it so they are all in cell b1. I've tried a dozen different combinations of commas, brackets, colons, etc. and searching "help" isn't helpful! How do I combine all these conditions? Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
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) | |||
Formula for conditional "ifs"? | New Users to Excel |