# 'IF' formula not working

The following formula is not returning any result in LibreOffice Calc. In Excel 2013, the result is **33,525**

Following is the formula:

IF(2500000<=B10>=1000000,1.2*B27,IF(5000000<=B10>=2500000,1.3*B27,IF(7500000<=B10>=5000000,1.5*B27,IF(10000000<=B101>=7500000,1.5*B27,IF(15000000<=B10>10000000,2,IF(20000000<=B10>=15000000,2.2*B27,IF(25000000<=B10>=20000000,2.5*B27,IF(30000000<=B10>=25000000,2.7*B27,IF(35000000<=B10>=30000000,2.8*B27,IF(40000000<=B10>=2.9*B27,IF(50000000<=B10>=40000000,3*B27,1)))))))))))

OK, let's look at this formula together ... Is that this piece -

`...10000000<=B101>=7500000,...`

- was written correctly? In other parts you check the value ofB10, but not ofB101Next questionable fragment -`...40000000<=B10>=2.9B27...`

Everywhere you compare with a constant, but here with a calculated expression...Tell us about these two pieces, and then we will tell you how to write the "B10 between the Value and Another Value"