if statements

Harley · Mar 6, 2008

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 · Mar 6, 2008

Create a VLOOKUP table instead

Fred Smith · Mar 6, 2008

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

Regards,
Fred.