ExcelBanter - if statements

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - if statements (https://www.excelbanter.com/excel-discussion-misc-queries/178978-if-statements.html)

Harley

if statements

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

Gary''s Student

if statements

Create a VLOOKUP table instead
--
Gary''s Student - gsnu200771

Fred Smith[_4_]

if statements

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

All times are GMT +1. The time now is 04:45 AM.