if combine min formula prob!!

[sampayor]

hi, i want to ask sumthing that quite difficult to me...there a marking point min 0,max 5 based on the result given,the result is between 0 to 100.below 75 considered 0...therefor, >=75 until 100 will get 0 to 5...there is my coding =IF(MIN(G10*5,5)<0,0,MIN(G10*5,5)) but if the G10 is 75 the point is 3.75,it suppose to get 1..any one can help??

 

[NARAYANK991]

Hi ,


You have mentioned that below 75 , the result should be 0 , and above 75 , till 100 , the result should vary from 0 till 5 ; how should the result vary ?


For what input values should the result be 1 ?


For what input values should the result be 2 ?


Can you specify these conditions for each of the results 1 , 2 , 3 , 4 and 5 ?


Narayan

 

[Hui]

Sampayor


Firstly, Welcome to the Chandoo.org Forums


Try: =5*(G10-75)/25

 

[sampayor]

thanks 4 ur quick reply master......there is no conditions for that(no lookup)...it is calculation..if 75 = 1, so 76 = 1.0x or 95=4.8x..i got problem when i want to combine calculation and formula..this is what is think about

=IF(MIN(G10*5,5)<0,0,xxxxxformulaxxxxx)..


G10 is in percent%...75/100..hope u can help

 

[sampayor]

Thanks....solved wif your calculation..