excel is not recognizing the range numbers

Asked

Viewed 34 times

0

This is the spreadsheet to calculate the tax due according to the billing: Total Gross Revenue in the last 12 months

         A               B             C          D
1                                   Alíquota  Faturamento
2            -       180.000,00     4,50%
3     180.000,01     360.000,00     6,54%      350.000,00
4     360.000,01     540.000,00     7,70%
5     540.000,01     720.000,00     8,49%
6     720.000,01     900.000,00     8,97%
7     900.000,01     1.080.000,00   9,78%
8    1.080.000,01    1.260.000,00   10,26%
9    1.260.000,01    1.440.000,00   10,76%

I made the following formula: =se(A3<=D3<=B3|C3|0) What is wrong?

excel

  • I sent the table formatted, but it came out all format and so it is difficult to understand what I want.

  • Ready, formatted. When adding something and you want it to keep formatting, select the snippet and click {} :)

1 answer

0

I believe the problem is this expression

A3<=D3<=B3

that is badly formatted. It is not possible to make multiple combination expressions, you can use the logical connective "E". (link) The correct curl expression that would be:

(A3<=D3)& (D3<=B3)

or

(A3<=D3) E (D3<=B3)

Browser other questions tagged excel

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