Bike Forums > Foo > Question about excel formula
 Register All Albums Elite Membership Forum Rules Calendar Search Today's Posts Mark Forums Read

 Foo Off-Topic chit chat with no general subject.

 06-01-10, 03:05 PM #1 phantomcow2 la vache fantôme Thread Starter     Join Date: Aug 2004 Location: NH Bikes: Posts: 6,266 Mentioned: 0 Post(s) Tagged: 0 Thread(s) Quoted: 1 Post(s) Question about excel formula Suppose I have a rule: If a number is equal to greater than 10, I want the number multiplied by 3. If a number is less than 10, I want the number multiplied by 2. Is there a way I can setup a formula in excel such that if I enter a number equal to or greater than 10, it multiplies by 3. And if I enter a number less than 10 in the same cell it automatically multiplies by 2, pursuant to the rule above? __________________ C://dos C://dos.run run.dos.run
 06-01-10, 03:15 PM #2 HardyWeinberg GATC   Join Date: Jul 2006 Location: south Puget Sound Bikes: Posts: 8,136 Mentioned: 15 Post(s) Tagged: 0 Thread(s) Quoted: 283 Post(s) =if(a1<10,a1*2, a1*3 )
 06-01-10, 03:16 PM #3 HardyWeinberg GATC   Join Date: Jul 2006 Location: south Puget Sound Bikes: Posts: 8,136 Mentioned: 15 Post(s) Tagged: 0 Thread(s) Quoted: 283 Post(s) I'm not paying to dress casually though
 06-01-10, 03:29 PM #4 phantomcow2 la vache fantôme Thread Starter     Join Date: Aug 2004 Location: NH Bikes: Posts: 6,266 Mentioned: 0 Post(s) Tagged: 0 Thread(s) Quoted: 1 Post(s) Hahaha, thanks . __________________ C://dos C://dos.run run.dos.run