Create an equation;
Hi,
If you know they always enrole for 12 or more hours then
=A1*10
Stop and think about it you will see the logic.
If they could enrole for less than 12 hours but the base fee was still 120
then
=120+MAX(A1-12,0)*10
--
If this helps, please click the Yes button.
Cheers,
Shane Devenshire
"daynek" wrote:
A student is a resident and they enroll for more than 12 hours, then their
tuition will equal $120 plus $10 per hour for every hour greater than 12.
The formula below calculates 12 hours @ $120 and 13 hours @ $130, I am not
sure how to automatically calculate additional hours.
=IF(A11<=12,"$120",IF(A1112,"$120"+"10"))
|