How to do excel multiplication that changes at a certain level? [closed]

I earn the amount 100 per hour. I currently have an excel sheet, that calculates my total number of hours x 100.

When I have worked more than 7.5 hour, I go into overtime, which means that i earn 150 instead. How do I add that to my excel function?

-
I have voted to close this question as off topic. The FAQ mentions "software that mathematicians use" but I am not sure that Excel is the sort of software that is intended. – Carl Mummert Sep 2 '12 at 23:24
I have flagged the question as off topic as well. I'm glad that answers were provided, but this is just not the ideal place for this question to remain. Based on this meta SE question, it seems this should be migrated to SuperUser. – Michael Boratko Sep 2 '12 at 23:25
While I agree with Carl very much (and voting to close as off topic), I just had to retag this. I think this is as far as it can get from [computer-science]. – Asaf Karagila Sep 2 '12 at 23:29
I'm sorry if I have created trouble. I'm glad for the answers – CSS_maniac Sep 2 '12 at 23:39

closed as off topic by Carl Mummert, Peter Tamaroff, Asaf Karagila, Rahul Narain, WilliamSep 3 '12 at 1:16

Questions on Mathematics Stack Exchange are expected to relate to math within the scope defined in the FAQ. Consider editing the question or leaving comments for improvement if you believe the question can be reworded to fit within the scope. Read more about closed questions here.

You didn't come to the ideal site for this sort of help, but what you could do is look up the syntax for IF statements and make your cell compute something like this:

IF hours.today > 7.5 THEN 100*7.5+150*(hours.today-7.5) OTHERWISE 100*hours.today

-

The simplest relationship to encode in Excel is probably

$\mathrm{earnings} = \min(x,7.5)*100 + \max(x-7.5,0)*150$

(Excel has max and min functions. Plug in your cell ranges where $x$ is.)

-