[mso] excel

Hello
I want to start by saying thank you and sorry for writing so much. I
appreciate your time. I was hoping if you could help me. I am trying to
create a calculator on excel. It is for estimating the cost of coverage for
commercial buildings. So far I have created a few drop down menus for the
user: Industry, Class, Square Ft, Rates. Whatever the user picks in the
industry menu, it will automatically change the options in the Class menu.
And whatever I pick in the Class it will give me different options in the
Square Ft menu. Here is my problem. Different Square Ft will have result in
different rates. However, sometimes I have two different rates for the same
Square Ft. For example, lets say I pick the following options, Industry:
Educational, Class: Gymnasium, Square Ft: 5-15SF, which will give me a rate
of 97.00. And with another example Industry: Habitational Class: Hotel
Square Ft: 5-15SF will give me a rate of 66.30. I know I'm suppose to use an
IF statement here but not sure how. Thanks again


*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, visit the group's homepage and use the dropdown 
menu at the top.  This will allow you to unsubscribe your email address or 
change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to share files with the group, you must join our Yahoo sister group. 
 This group will not allow for posting of emails, but will allow you to join 
and share problem files, templates, etc.:  
http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for FILE 
SHARING ONLY.

If you are using Outlook and you see a lot of unnecessary code in your email 
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************

Other related posts: