Solved Excel greater than less than?

November 27, 2012 at 21:07:56
Specs: Macintosh
If a number in a column is less than 100 I want the function in the next column over to take that number and calculate 15 percent of that number. If it is over 100 then I want the calculation of that number to the calculation of 20 percent of that number.
Could you please tell me how this could be done?
Thank you!

See More: Excel greater than less than?

Report •


#1
November 28, 2012 at 07:14:39
✔ Best Answer
In cell B1, try this:

=IF(A1<=100,A1*15%,A1*20%)

MIKE

http://www.skeptic.com/


Report •

#2
November 28, 2012 at 10:57:50
What do you want to happen if the number equals 100?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Related Solutions


Ask Question