"Derrick" wrote:
i was wondering if this would go into cell blocks - ie use something
like: =IF( ... , ... , ...)

Sorry. I completely misread your first posting, which was very clear ("im
not sure how to put into excel formulas"). Mea culpa!

If #M and #H are individuals cells, then:

In #M: =if(A1="SMW",if(MW+2.5=TW,2,1),if(A1="SMH",0,x))

In #H: =if(A1="SMH",if(MH+2.5=TH,2,1),if(A1="SMW",0,y))

assuming that MW, TW, MH and TH are actually cell references or named cell
references.

Note: For #H, if you prefer to mimick the pseudocode exactly, then:

=if(A1="SMW",0,if(A1="SMH",if(MH+2.5=TH,2,1),y))

Also, instead IF(MH+2.5=TH,2,1), you could write (MH+2.5=TH)+1. But that
might be trickier for you to work with if you wanted 100 and 10, for
example.


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

"Derrick" wrote in message
...
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,