Doubt in excel

Asked

Viewed 42 times

0

I need the following formula: If salary less 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%

excel
  • 2

    What have you tried so far?

  • 1

    this is so simple that it is possible to solve only in the formula bar..

1 answer

3

taking into account 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")))

Browser other questions tagged excel

You are not signed in. Login or sign up in order to post.