What if I wanted to add more results?

I can't seem to get it to work by adding + 5.99*(AND(A13.50,A1<4.50)

"Bernard Liengme" wrote:

=IF(AND(A10.01,A1<2.50),3.99,IF(AND(A12.50,A1<3. 50),4.99,"NO REPLY"))
or remove NO REPLY and have an empty ""

If you can live with zero when neither case applies:

=3.99*AND(A10.01,A1<2.50) + 4.99*(AND(A12.50,A1<3.50))

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Tigerwould" wrote in message
...
I'm trying to return multiple results using IF function for the following.

If A1 is greater that 0.01 and less than 2.50 then enter 3.99, but if A1
is
greater than 2.50 and less than 3.50 then enter 4.99.

I can do it for one:

=IF(AND(J22.50,J2<3.50),"4.99")

But not multiples.

Help!