Probably simple but...

P

pvautour_4242

This is my first post, and I'm sure the answer to my question is
probably a simple one...maybe why I can't think of it?

Anyway, here is my questions: I have built a sheet that tells me the
hours I have worked for any given month. What I'd like to be able to do
next is calculate how much $$ I have made during one day. Sounds easy,
but I have 2 jobs and receive a premium when I work one of those jobs.
I think I should be using an if/then statement, but am stumped as to
how to get it to work.

Here is the "plain english" version of what I am trying to do: if I
work job1 then hrs worked * $24.00, if I work job2 then hrs worked *
$30.00.

Any help would be appreciated.

pvautour
 
D

daddylonglegs

If cell A1 gives the job number (1 or 2) and B1 the number of hour
worked

=IF(A1=1,24,IF(A1=2,30))*B
 
S

Sandy Mann

Assuming that you have dates in Column A, Job No (Job 1 etc) in Column B and
the hours worked in Column C and also assuming that you have the hours
entered as XL times (ie 8:00 not 8.00) then for Job 1 try:

=IF(B3="Job 1",C3*24*24,C3*24*30)

and format the cell as currency.

Being as we are using C3*24 in both parts of the IF() function it can be
re-written as:

=C3*24*IF(B3="Job 1",24,30)


--
HTH

Sandy
In Perth, the ancient capital of Scotland

[email protected]
[email protected] with @tiscali.co.uk


"pvautour_4242" <[email protected]>
wrote in message
news:p[email protected]...
 
Top