View Single Post
Old 01-02-07, 12:24 PM   #1
Jelster
Guest
 
Posts: n/a
Default Excel Help - "IF" function

I'm working on a fairly basic spreadsheet to work out prices for given services.

I have a drop down menu in on box containing 4 services ; Each one has a set up cost and monthly charge (all listed on the sheet)

What I want to do is select one of the services, then for the cell marked "Set Up" to drop in the set up cost for that service, and like wise for the monthly charge.

I can make it hapen for one service, but I can't work out how to make it do all 4....

Can anybody help ???

.
  Reply With Quote