View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tigerwould Tigerwould is offline
external usenet poster
 
Posts: 3
Default 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!