Bikeforums.net is a forum about nothing but bikes. Our community can help you find information about hard-to-find and localized information like bicycle tours, specialties like where in your area to have your recumbent bike serviced, or what are the best bicycle tires and seats for the activities you use your bike for.phantomcow2
06-01-10, 03:05 PM
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?
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?