IF, ELSEIF STATEMENTS

[Derrick]

Hey!
I have a series of If/else if statements that im not sure how to put into
excel formulas.
My variables are: 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,

 

[JoeU2004]

PS....

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 -----

 

[Derrick]

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?

 

[Derrick]

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?

 

[JoeU2004]

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 -----