excel is not recognizing the range numbers

Navigation
0

This is the spreadsheet for calculating the tax due due to 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's wrong?

    
asked by anonymous 21.05.2017 / 01:27

1 answer

0

I believe the problem is this expression

  

A3

21.05.2017 / 01:49
capture html from an external page grab data from the table and send via Ajax Progressively Removing from the List