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
Bookmarks