Conditional formula
in [Functions]
|
Prev: Latest Taxation Books available at jain book depot LATEST BOOK RELEASES
Next: Conditional formula yeilds non-number result
From: RichM on 29 May 2010 12:41 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.
From: RichM on 29 May 2010 12:44 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. >
From: Dana DeLouis on 29 May 2010 13:16 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. >
From: RichM on 29 May 2010 13:45
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. > |