Take the 2-minute tour ×
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.

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

closed as off topic by Carl Mummert, Pedro Tamaroff, Asaf Karagila, Rahul, William Sep 3 '12 at 1:16

Questions on Mathematics Stack Exchange are expected to relate to math within the scope defined by the community. 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 reopening questions here.If this question can be reworded to fit the rules in the help center, please edit the 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. –  process91 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
add comment

2 Answers 2

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
add comment

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
add comment

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