View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
daynek daynek is offline
external usenet poster
 
Posts: 4
Default Create an equation;

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