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"))

Based on the problem, the if statement should be =if(a11,<=12,120,(a11*10))
format the cell that contains the statement to currency or accounting to get
the $ sign to print.

"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"))

I think this formula is a good solution but has one comma out of place. Try
= if(a11<=12,120,(a11*10))

Alternatively, if you're just trying to establish a minimum cost of $120 or
$10 per hour, you could also use:

=MAX(120,D11*10)


"djungst" wrote:

Based on the problem, the if statement should be =if(a11,<=12,120,(a11*10))
format the cell that contains the statement to currency or accounting to get
the $ sign to print.

"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"))

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"))