Use Vlookup instead. It will make your life much easier.

Regards,
Fred.

"Harley" wrote in message
...
I need an if statement to handle 10 different possibilities. if
ay9.799,"180",if ay9.599,"160",if ay9.399,"140" etc....

thanks,
harley