Solved Excel 2007 Formular As A Percentage

Microsoft Ms oem office pro 2007 v2
November 2, 2011 at 04:33:08
Specs: Windows 7, Intel Core 2 Duo 6300
Good Day All

What I am looking to do is get the percentages of 2 cells in excel 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


See More: Excel 2007 Formular As A Percentage

Report •

#1
November 2, 2011 at 06:52:11
✔ Best Answer
You could do something like:

=IF(A1/B1>=90%,90%,A1/B1)

MIKE

http://www.skeptic.com/


Report •

#2
November 2, 2011 at 07:14:46
Hi Mike

I had already solved this earlier on:

=IF(B3/E3<0.9,B3/E3,"90%")

But thanks for your help.

Cheers
Tor Fey


Report •

#3
November 2, 2011 at 07:30:41
Tor fey:

You are aware that as far as Excel is concerned, "90%" and 90% are not the same thing, right?

These 2 formulas are not equivalent:

=IF(B3/E3<0.9, B3/E3, "90%")

=IF(B3/E3<0.9, B3/E3, 90%)

The first formula will put the text string 90% in the cell, while the second will put the numerical value 0.9 in the cell, which can then be formatting to display the numerical value 90%.

This may or may not matter, depending on how you plan to use the 90%, but what you are in fact doing is putting a number in the cell when the IF function evaluates the TRUE condition (B3/E3), but a text string when the IF evaluates to the FALSE condition of "90%".

Unless you specifically need the 90% to be a text string, many would consider your use of the quotes to be incorrect.

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


Report •
Related Solutions


Ask Question