NEED HELP WITH FORMULAS

[Guest]

I AM USING MICROSOFT EXCEL FOR 2003..NEED HELP TO MAKE A FORMULA THAT SHOWS
AS SUCH...IF JANE COME TO SCHOOL 3 DAYS AM ONLY THEN HER RATE SHOULD SHOW
20.00 IN THE CELL WHEN I TYPE 3AM? I HAVE INCLUDED SOME DATA FOR HELP!!!
PLEASE HELP ME...I COULDN'T FIGURE IT OUT...TRIED TO USE MATCH FORMULA? NOT
SURE WHERE TO GO FROM HERE?
Names:
Destyne
Carl
Tyler
Campbell

3 days
Am only 20.00
Pm only 29.00
Am and pm 39.00

4 days
Am only 22.00
Pm only 32.00
am and pm 42.00

5days
am only 25.00
pm only 35.00
am and pm 45.00

 

[Guest]

Hi, I think that you need to be a little more clear. In column A you have a
list of names. Do you want to type in "3AM", "3PM", "3Both", "4AM", etc. in
column B next to each name and have excel lookup the appropriate charge and
enter it into collumn C?

 

[Guest]

KEN,

Yes, that is exactly what i would like to do. I would like to set it up
like this... for example...

column A column B column C column D column E column F column
G
Name Week 1 Week 2 Week 3 Week 4 Week 5
Total month
Rachel 3am 3am 3am 3am 3am
100.00

Any help with this would be greatly appreciated! thanks so much!