Cycling and bicycle discussion forums. 
   Click here to join our community Log in to access your Control Panel  


Go Back   > >

Foo Off-Topic chit chat with no general subject.

User Tag List

Reply
 
Thread Tools Search this Thread
Old 06-01-10, 03:05 PM   #1
phantomcow2
la vache fantôme
Thread Starter
 
phantomcow2's Avatar
 
Join Date: Aug 2004
Location: NH
Bikes:
Posts: 6,266
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 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
phantomcow2 is offline   Reply With Quote
Old 06-01-10, 03:15 PM   #2
HardyWeinberg
GATC
 
Join Date: Jul 2006
Location: south Puget Sound
Bikes:
Posts: 7,555
Mentioned: 2 Post(s)
Tagged: 0 Thread(s)
Quoted: 75 Post(s)
=if(a1<10,a1*2, a1*3 )
HardyWeinberg is offline   Reply With Quote
Old 06-01-10, 03:16 PM   #3
HardyWeinberg
GATC
 
Join Date: Jul 2006
Location: south Puget Sound
Bikes:
Posts: 7,555
Mentioned: 2 Post(s)
Tagged: 0 Thread(s)
Quoted: 75 Post(s)
I'm not paying to dress casually though
HardyWeinberg is offline   Reply With Quote
Old 06-01-10, 03:29 PM   #4
phantomcow2
la vache fantôme
Thread Starter
 
phantomcow2's Avatar
 
Join Date: Aug 2004
Location: NH
Bikes:
Posts: 6,266
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Hahaha, thanks .
__________________
C://dos
C://dos.run
run.dos.run
phantomcow2 is offline   Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off



All times are GMT -6. The time now is 07:14 PM.