Excel 2007 Formular As A Percentage

**Tor_Fey** · 11-02-2011, 08:12 AM

Good Day All

What I am looking to do is get the percentages of 2 cells in excell up to 90% but not over.
So even if the percentage is 100% I only want it to show the result as 90%; is this possible? and what would the formula be?

Many Thanks
Tor Fey

**MarvinP** · 11-02-2011, 08:16 AM

Hi Tor_Fey and welcome to the forum,

If your two cells are A1 and B1 where A1 is the numerator and B1 is the denominator then try this formula.

=IF(A1/B1>0.9,0.9,A1/B1)

**tom1977** · 11-02-2011, 08:17 AM

look at attachment

**Tor_Fey** · 11-02-2011, 08:33 AM

Hi tom1977

Will this formula include all the other percentages? - for example if the percentage of given numbers is supposed to be 70% will this display 70% or will it only display 90% all the time?

Many Thanks
Tor Fey

**tom1977** · 11-02-2011, 08:39 AM

yes my formula (in column D) include all the other percentages. It puts 90% only in situation when the real percentage is > 90%.
I have used text "90%" inside it so if You want make calculation on the results of this formula You should use one proposed by MarvinP

**Tor_Fey** · 11-02-2011, 08:51 AM

Hi Tom1977/MarvinP

Thank you so much for the help, i have now managed to solve this problem thanks to you.
Thanks for making my day go a little easier :@)

Ever grateful
Tor Fey