Michael,

I should have done a little more that just throw the formula out there
because if you've never used an IF statement you're not likely to understand
the parts of it. I'll be more careful next time.

Thanks for stepping in.
Scott



"Michael M" wrote:

Ashleigh
Scot was simply using 1,2,3,4 as examples of answers when certain criteria
were met

Regards
Michael M

"2604ashleigh" wrote:

Thank you very much. One question, what does the '3' represent?

"Scott" wrote:

=IF(A1<10,1,IF(AND(A1=10, A1<20),2,IF(AND(A1=20, A1<30),3,4)))

"2604ashleigh" wrote:

Please help.
Want to create a formula that allows for:
1. if amount in cell next to it is less than an amount, to come up as one
amount.
2. if amount in cell next to it is more than an amount, to come up as
another amount,
The difficult bit for myself...
3. if amount in cell next to it is more than another amount on top of that,
to come up as another amount.

If you can help, that would be fantastic.