# 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 AllWhat 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 ThanksTor Fey

See More: Excel 2007 Formular As A Percentage

#1
November 2, 2011 at 06:52:11
 You could do something like:=IF(A1/B1>=90%,90%,A1/B1)MIKEhttp://www.skeptic.com/

Report •

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

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