formula Help

K

khansab143

Hi Guys how r u,
I need a help if there is anyone can figure out.

I am doing a calculation
lets say target = 30 if any thing goes above 30 that goes (-)
=(100-30)*.1667 = 11.67
=(100-0)*.1667= 16.67 target ment

that is same thing i am doing with 600 limit
if any thing above 600 it count against the 16.67% and if it less tha
600
it count in favore.

Regards
 
B

Barbara Wiseman

khansab143,

Not quite sure I understand but this may help you, but if not please point
out what I have not understood.

The formula looks at the value in A1
and says if A1 is less than or equal to 600, then (100-A1)*0.1667
If not (ie A1 is more than 600), then 100*0.1667
=IF(A1<=600,(100-A1)*0.1667,100*0.1667)

Good luck
Barbara
 
Top