"Gaurav" wrote:
so if a person's average daily sale is between
14 and 14.49, he gets 100%.
[....]
so basically each .5 increase in the figure will
increase the %age by 5.

Ostensibly, I think you want (A1 = daily sale):

=1 + int((A1-14)/0.5)*5%

formatted as Percentage.

But what if the daily sale is less than 14?

Perhaps you want one of the following:

' all sales <= 14 result 100% as well
=1 + int(max(0,A1-14)/0.5)*5%

' sales < 14 result in 0%
=if(A1<14, 0, 1 + int((A1-14)/0.5)*5%)

' reduce 100% by 5 pct pt for each 0.5 less than 14
=max(0, 1 + int((A2-14)/0.5)*5%)


----- original message -----

"Gaurav" wrote in message
...
Hi,

I tried to explain the problem in the subject like but i know i failed
miserably. Anyway, here is the problem. so if a person's average daily
sale is between 14 and 14.49, he gets 100%. If it is between 14.5-14.9 he
gets 105%. if it is 15.0-15.49, he gets 110% and so on. But I can not put
so many conditions in one formula...

so basically each .5 increase in the figure will increase the %age by 5.
But if it is less than .5 increase, it stays where it is. so if it is 14.6
or 14.7...14.9, it still remains 105% and the moment it reaches 15, the
%age increase by 5 more and becomes 110%

I hope I was able to explain it properly. Please help.

Thanks