Solved In excel function key, set the % not more than 100.

April 5, 2013 at 22:05:04
Specs: Windows XP
I want to set the percentage in my worksheet. If the percentage more than 100%, I want to show 100%. How to set up A1 = 150
B1 - 50
A1/B1*100 is over 100% percentage, how to make it show 100%.

See More: In excel function key, set the % not more than 100.

Report •

#1
April 6, 2013 at 08:22:46
✔ Best Answer
Try this:

=IF(A1/B1*100>100,100,A1/B1*100)


MIKE

http://www.skeptic.com/


Report •

#2
April 13, 2013 at 00:04:30
Thank you. It is okay now.

Report •
Related Solutions


Ask Question