Greater than and less than formula error

Hi,

From the particular value i am trying to arrive marginal relief. Sample file attached. getting error for more 1 CR Net value. can you try to update with correct formula

cell B row 8 i have given a condition of
1) less than 50L, 0
2) Above 50 L to 1 Crore
3) 1 crore to 2 crore (getting error)

Thanks.. Senthil

There is a REF error in your formula
Please explain the logic in words. You can't expect us to decipher your formula to understand it.
Thanks
(BTW what do "L" and "crore" stand for?)

Hi,

details given below

Marginal Relief amount to arrive only for scenario 2 and 3 which is mentioned below:
L = Lakhs

1) less than 50 Lakhs = Marginal relief = 0
2) Above 50 Lakhs to 1 Crore = Marginal relief to be calculate, if result is less than 0, then need to consider as 0
3) 1 crore to 2 crore = Marginal relief to be calculate, if result is less than 0, then need to consider as 0

In the revised attached excel file, i have calculated all 3 scenario separately in column F, G and H, when i calculate all three scenario separately, getting answer in Row 6.
if i combine all three formula, getting error for 1 corer to 2 crore (Refer column B Row 6) in revised attached excel
Hope this clarify.

Thanks...Senthil

I still have no idea what "lakhs" are or what " crore" means

Hope below helps you


1) less than 5 Million = Marginal relief = 0
2) Above 5 Million to 10 million = Marginal relief to be calculate, if result is less than 0, then need to consider result 0
3) 10 Million to 20 crore = Marginal relief to be calculate, if result is less than 0, then need to consider as 0