Doubt in excel [closed]

0

I need the following formula: If salary lower than R $ 1399.12, calculate 8% If salary greater than R $ 1399.13 and less than R $ 2331.88, calculate 9% If salary greater than R $ 2331.89 and less than R $ 4663.75, calculate 11%.

    
asked by anonymous 14.07.2015 / 22:16

1 answer

3

Considering that your reference will be in cell A1, you can use the following formula:

=SE(A1<=1399,12;A1*8%;SE(E(A1>=1399,13;A1<=2331,88);A1*9%;SE(E(A1>=2331,89;A1<=4663,75);A1*11%;"extrapolou")))
    
14.07.2015 / 22:42