MAX/MIN functions on cells formatted as Percent.

S

Swiatkowski Peter

Hello,

I am able to use MAX/MIN functions on cells formatted as Numbers, however
not on cells formatted as Percent.

How can "some" function be used to convert Percent to Numbers so that
MAX/MIN function can be used ?

Peter
 
P

Peo Sjoblom

No difference, percentage = numbers unless you use text, if so copy an empty
cell, select the percentage and do edit>paste special and add
That will convert it as well, otherwise format as percentage
 
R

Ron Rosenfeld

Hello,

I am able to use MAX/MIN functions on cells formatted as Numbers, however
not on cells formatted as Percent.

How can "some" function be used to convert Percent to Numbers so that
MAX/MIN function can be used ?

Peter
Click to expand...

There is no reason why you should not be able to use MAX/MIN functions on cells
formatted as percent.

You are possibly entering an improper formula, or not understanding the nature
of your data.

For help, please post your formula, your inputs, your expected outputs, and
your actual outputs.


--ron
 
Top