Sir,
How should I enter the formula (argument) in the formula bar for the
following problem:
Where the figure in a specified column (suppose A1) does not exceed
110,000 then the result in Column A2 should be NIL.
Where the figure in the same column, i.e. in Column A1 exceeds 110,000
but does not exceed Rs.150,000, then the result in column A2 should be
10% of the figure by which figure in Column A1 exceeds 110,000.
Where the figure in Column A1 exceeds 150,000 but does not exceed
250,000, then the result in column A2 should be 4000 plus 20% of the
figure by which the figure in column A1 exceeds 150,000.
Where the figure in Column A1 exceeds 250,000, the the result in
Column A2 should be 24000 plus 30% of the figure by which the figure
in column A1 exceeds 250,000.
Awaiting the reply,
With regards,
N.S. Nair.
