Excel 2007 : 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.

Please Login or Register  to view this content.

**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