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

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



Report •

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

I had already solved this earlier on:


But thanks for your help.

Tor Fey

Report •

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