However, if you're looking to expand this to 11 possibilities,
you might try something like this:

=LOOKUP(K5,{0,3,6,9,12,15,18,21,24,27,30;50,100,18 0,260,340,420,500,580,660,740,820})

I guessed at your parameters.
You can correct them as needed.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Paula" wrote in message
...
That worked, Dave. Thank you so much!

"Dave Peterson" wrote:

One mo

=IF(L42<3,50,IF(L42<5,100,""))

I don't see a reason to check for 2 and < 5 in that second if().

And I changed the text to real numbers.


Paula wrote:

This is the formula I put in:
=if(L42<3,"$50",if(L422<5,"$100")). Instead of returning $50 or $100
it
returns FALSE. What am I doing wrong?

Thank You.

--

Dave Peterson