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