Yes, but how many ranges do you have? There is a limit of 7 nested
functions that you can have in Excel 2003 and earlier, so if you have
more ranges than 7 we can't use nested IFs - we have to do this in a
different way.

What are your ranges? Do they always go up in steps of 100, or does it
go something like 300-400, 400-500, then 500-750, 750-1000, then
1000-1500? What is the largest value that A1 can take? (And do you
have sufficient entries in column C?)

Pete

On Apr 24, 3:02*pm,
wrote:
Pete,
Sorry about that. That's a typo. The 2nd range is 50-100, the third range is
100-200, etc. I know excel doesn't understand "and so on", I was just trying
to illustrate that *I have multiple ranges, not just the ones I listed.

Thanks



"Pete_UK" wrote:
What is the range of the second criteria? 50-100 or 50-200? How many
criteria ranges will you have, and what are they? (Excel doesn't
understand "... and so on ...").

Pete

On Apr 24, 2:24 pm,
wrote:
I'm trying to set a value that depends on another value being between two
values. For example: IF A1 is between 0-50, then A2 is B2*C2. If A1 is
greater then 50, but less then 100 but less then 200, then A2 is B2*C3.. If A1
is greater then 200 but less then 300, then A2is B2*C4. And so on.- Hide quoted text -

- Show quoted text -