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,