Expanding this formula

[Mikest]

Hi All,

I want to add extra condition to this statement, but having problems doing so.

Standard formula
=IF(G6<=2200,L10)
This works fine, want to add IF(G6>2200,< 2500,L11) OR IF(G6>2500 <3000,L12)

Any help is much appreciated..
Ta
Mike

[dpolson]

Try this:

=IF(G6<=2200,L10,IF(G6<2500,L11,IF(G6<3000,L12,"")))

You can embed up to 7 if statements. If you need more than that, there are ways around it by using more than one cell, each with your "maximum IF" equation, then a consolidation cell that sums the other cells containing your "maximum IF" equations. There are likely more efficient ways to do this, but since I don't know any better, I've found this works for me.

Dale

[Mikest]

Thanks Dale,
That works fine. I have a heap of work like that, thanks again.
Mike

[Jay Petrulis]

On 2002-04-17 21:24, dpolson wrote:
Try this:

=IF(G6<=2200,L10,IF(G6<2500,L11,IF(G6<3000,L12,"")))

You can embed up to 7 if statements. If you need more than that, there are ways around it by using more than one cell, each with your "maximum IF" equation, then a consolidation cell that sums the other cells containing your "maximum IF" equations. There are likely more efficient ways to do this, but since I don't know any better, I've found this works for me.

Dale

Hi Dale,

Don't sell yourself short. Your response is *the* standard way to do this, and it is so for a reason -- because it is straightforward and it works (very well). Nobody will find a solution that is significantly more efficient.

Nice job.

Bye,
Jay