Hello :)

I have a little problem i have min value 650 and max value 1000 i want to get % from 100% like

=sum(650min,1000max(value700))%

really i have no idea how i should make this work

i'm newbie on excel so i hope i get some kind of help :)

Hi,

Please select the cell, and use the "Percent style" commend.

Loction:

Home Tab>Number Group>%

Qucik Key:

Ctrl+Shift+%

For more detail information, please refer to the following link:

http://office.microsoft.com/en-us/excel-help/calculate-percentages-HP001141712.aspx

Regards,
George.zhao

Hi,

Im sorry that I miss understood something.

Please try to do following simple example:

= ((700-650min)/( 1000max-650min)%

Regards,

George Zhao
TechNet Community Support