i think i have it figured out.
B1 =IF(A1="SMW",IF((MW+2.5)=TW,#M=2,0),If(A1=SMH,#M=1 ,0))
B2 =IF(A1="SMH",IF((MH+2.5)=TH,#H=2,0),If(A1=SMH,#H=1 ,0))

where, MH,MW, TW, TH, #M, #H are all referenced cell blocks.

is this logical?

"Derrick" wrote:

thanks so far,
i was wondering if this would go into cell blocks - ie use something like:
=IF( ... , ... , ...) with some more nested 'IF's, and the pseudonames being
cell blocks
is that possible?, or do you have a better idea for where the code will go?

"JoeU2004" wrote:

PS....

I wrote:
if SMW is selected(from drop down list) then
if (MW+2.5)= TW then
#M :=2
Else
#M :=1
elseIf SMH is selected(from drop-down list) then

You need an End If statement before ElseIf; viz:

Alternatively:

if SMW is selected(from drop down list) then
if (MW+2.5)= TW then #M :=2 Else #M :=1
elseIf SMH is selected(from drop-down list) then


I presume this is pseudocode and you know that #M is not a valid variable
name. But FYI, M# is a valid name, forcing the type to Double.


----- original message -----

"JoeU2004" wrote in message
...
"Derrick" wrote:
I have a series of If/else if statements that im not sure how to put into
excel formulas.

I assume you just have a syntax question. I think a careful reading of
the "If...Then...Else statement" help page should answer your questions.


if SMW is selected(from drop down list) then
if (MW+2.5)= TW then
#M :=2
Else
#M :=1
elseIf SMH is selected(from drop-down list) then

You need an End If statement before ElseIf; viz:

if SMW is selected(from drop down list) then
if (MW+2.5)= TW then
#M :=2
Else
#M :=1
End If '<-----
elseIf SMH is selected(from drop-down list) then


elseIf
#M:=x
#H:=y
EndIF

Since you have no condition for the last clause, it should be simply Else,
not ElseIf; viz:

Else '<-----
#M:=x
#H:=y
EndIF


----- original message -----

"Derrick" wrote in message
...
Hey!
I have a series of If/else if statements that im not sure how to put into
excel formulas.
My variables a Standard Module Width (SMW)
Standard Module Height (SMW)
Module Width, Module Height (MW), (MH), respectively
Total Height, Total Width (TH) and (TW), respectively
# of Mullions , # of Horizontals (#M), (#H), respectively
and 2 user defined variables, X, Y

Here goes:
if SMW is selected(from drop down list) then
if (MW+2.5)= TW then
#M :=2
Else
#M :=1
elseIf SMH is selected(from drop-down list) then
if (MH+2.5)= TH then
#H:=2
Else
#H:=1
elseIf
#M:=x
#H:=y
EndIF

Dont worry about how i select the SMW,SMH - i have all that.
Any help would be spectacular!
Thanks,