formula / lookup table

[wbaid]

I have to do lookup table.

something like this

if (a-b)>=75% then (a-b) * 25 and if (a-b)>-60% and less then then 74.9% then (a-b) * 15

I know its too complicated but any help will be appreciated.

Thank you.

 

[BobUmlas]

I don't see how this is any kind of lookup table. But for A1 & B1:
=IF(A1-B1>=75%,(A1-B1)*25,if(A1-B1>=60%,(A1-B1)*15,0))

You didn't say what you want to see if a-b is <60%, so I entered 0. Also, your example said >-60%, and I'm assuming you meant >=60%

 

[delaneyjm]

you've only listed two items which is hardly worth setting up a lookup table.

You could try this formula instead

=IF((A1-B1)>75%,(A1-B1) * 25,IF(AND((A1-B1)>-60%,(A1-B1)<74.9%), (A1-B1) * 15))