Trying to use a payscale

**Thrasher** · 01-02-2012, 11:06 AM

Hello, I need some simple help. I will be plugging in the number of students that show up to a class into an excel sheet and I need the price to be paid to the instructor to be automatically calculated into another collum. The table is as follows: If 3 to 5 students show up the instructor is paid 26 If 6 to 7 students show up the instructor is paid 42 If 8 to 10 students show up the instructor is paid 52. I can’t remeber exactly how to do this and would appreciate your help, thank you.