"IF" STATEMENTS ?????

[paullaup]

Hi, Im not an experienced excel user. Im trying to set up an equation that will round up the baseplate thickness value in the cell to a value more practical.
i.e. when I get a thickness of .083inches, I would like the cell next to it to read "use a 1 inch base plate. Ive got this far, and it works for one condition.
I have : IF(C82<1,(&quot;use a 1inch baseplate&quot),

This is fine for all values less than 1, but I also want to add a function for other values, like:
ifC82>1, BUT <1.25, &quot;USE A 1.25 INCH BASEPLATE&quot;,....and so on.

Has anyone got any ideas???

 

[aviat]

You could also consider Case Select. It is a way of looping. I haven't used it but John Walkenbach covers it in his books.

 

[GeorgeFletcher]

Paullaup.Since you require standard thickess plates why not create a table of thicknesses and LOOKUP this table?

 

[joerd]

That was suggested two weeks ago by bltseattle.

Cheers,
Joerd

Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.

 

[paullaup]

Thanks all, foir your help. I've really learned a lot