Tell me more ×
Mathematics Stack Exchange is a question and answer site for people studying math at any level and professionals in related fields. It's 100% free, no registration required.
up vote -1 down vote favorite

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?

share|improve this question
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
2  
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, William Sep 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.

2 Answers

up vote 0 down vote accepted

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

share|improve this answer
up vote 3 down vote

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

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.