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%.
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%.
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")))