Multiple If Statements
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!
|