Help Request

[Monte Comeau]

I am trying to create a Worksheet for our Golf Clubs membership list.
I want to be able to simply fill in the members code in a cll and the
coresponding data will be filled in an adjacent cell.

For example, if the member is a Senior or a Junior I would enter a S or J in
the cell adjacent to his name, this would fill in the next sell with the
amount of dues owed and then i could use the info from that cell to apply
discounts etc.

Whay I have done only works with one cell...when I use the FILL DOWN feature
my formula no longer works. My formula is as follows.

=IF(C9="A",375)*OR(C9="S",350),*OR(C9="J",125)*OR(C9="ST",175)

Where A,S,J,ST are all different codes used for the different age groups and
the 375, 350, 125, 175 are the amounts of the dues payable.

Any help would be greatly appreciated.


Monte

Salmo Golf Club

 

[Norman Harker]

Hi Monte!

Try:

=IF(C9="A",375,IF(C9="S",350,IF(C9="J",125,IF(C9="ST",175,""))))

It does what you ask and defaults to "" if C9 is empty or some other
string.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Jason Morin]

An alternative:

=VLOOKUP(C9,{"A",375;"S",350;"J",125;"ST",175},2,0)

HTH
Jason
Atlanta, GA

 

[Monte Comeau]

Thanks!