if statements

[Harley]

I need an if statement to handle 10 different possibilities. if
ay>9.799,"180",if ay>9.599,"160",if ay>9.399,"140" etc....

thanks,
harley

 

[Gary''s Student]

Create a VLOOKUP table instead

 

[Fred Smith]

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

Regards,
Fred.