Nested IF help

  • Thread starter Thread starter Bean
  • Start date Start date
B

Bean

I am trying to write a nested if so if the value in cell A1 falls
within a dollar range an amount is entered into cell b1. sounds easy
but I can't get it to work. It only works when the amount in A1 is
less than 750, any other amount returns a "not found". I don't see
what I am missing.
here is my formula:
=IF(A1<750,"no commission",IF(A1>=750<1499,"50",IF(A1>=1500<4999,"100",IF(A1>=5000<9999,"150",IF(A1>=10000<19999,"200",IF(A1>=20000<29999,"300","not
found"))))))
Thanks for your help.
 
You need to use AND. For example:

=IF(AND(A1>=550,A1<1499),50,IF(AND(---,---),---, etc.

HTH
Jason
Atlanta, GA
 
Hi
you received several comments to this question some days ago. Have you tried
them?. If yes what did not work for you exactly?
 
Back
Top