This is a .NET development group, not an Excel help group. ...Glenn
On Tue, Nov 4, 2008 at 1:55 PM, NS Nair <[EMAIL PROTECTED]> wrote: > > 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. >
