condition formula?

[Lovelock, David]

Can anyone help me with a formula or a VB code add in. I have a field
calculating square footage. I need to add a value for scrap to the
sqaure footage calculation but that value will change based on material
thickness. For example if I am fabricating using material up to 1/2"
thick I add 2 inches to each X Y dimension, if it is greater than 1/2"
thick I want to add 3" to each X Y. My user picks material form a dop
down list I created so each individual material selection has a
corresponding numberic value (1 - 10) I want to say if values 1,3,5,7,9
are in cell C11 then add 2 to each XY, if values 2,4,6,8,10 are in cell
C11 then add 3 to each XY.

Any suggestions?

Dave

 

[Jason Morin]

=ISEVEN(C11)+2+X
=ISEVEN(C11)+2+Y

where X and Y are values or cell references.

HTH
Jason
Atlanta, GA

-----Original Message-----

Can anyone help me with a formula or a VB code add in. I have a field
calculating square footage. I need to add a value for scrap to the
sqaure footage calculation but that value will change based on material
thickness. For example if I am fabricating using material up to 1/2"
thick I add 2 inches to each X Y dimension, if it is greater than 1/2"
thick I want to add 3" to each X Y. My user picks material form a dop
down list I created so each individual material selection has a
corresponding numberic value (1 - 10) I want to say if values 1,3,5,7,9
are in cell C11 then add 2 to each XY, if values 2,4,6,8,10 are in cell
C11 then add 3 to each XY.

Any suggestions?

Dave


------------------------------------------------

~~View and post usenet messages directly from http://www.ExcelForum.com/

~~Now Available: Financial Statements.xls, a step by step

guide to creating financial statements

 

[Lovelock, David]

Jason - I don't quite understand your formula. What does =ISEVEN do fo
me? Thanks for the example. I just need to understand it better.

Dav