If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|