# Foo - Question about excel formula

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.

View Full Version : Question about excel formula

phantomcow2
06-01-10, 04: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?

HardyWeinberg
06-01-10, 04:15 PM
=if(a1<10,a1*2, a1*3 )

HardyWeinberg
06-01-10, 04:16 PM
I'm not paying to dress casually though

phantomcow2
06-01-10, 04:29 PM
Hahaha, thanks :).