Hi,

I'm trying to create a Macro that implements an IF loop.

Here's what the loop would be like:

a = low end of range ; b = high end of range ; x = salary ; y = employer's contribution ; z = employee contribution
(a and b are 2 values that are always 19.99 apart. a can start from any value.)

if a<x<b
y = b * 0.13
z = b * 0.11
else
a = a+20
b = b+20
(loop back to top)

end

So basically, I want the macro to check the value in a cell, see if it fits the range, find 13% of b and enter that into one cell and find 11% of b and enter that into another adjacent cell.

Thanks