Probably simple but...

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

=IF(A1=1,24,IF(A1=2,30))*B1

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

sandymann2@mailinator.com
Replace@mailinator.com with @tiscali.co.uk


"pvautour_4242" <pvautour_4242.27183y_1146324600.3521@excelforum-nospam.com>
wrote in message
news:pvautour_4242.27183y_1146324600.3521@excelforum-nospam.com...
>
> 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
>
>
> --
> pvautour_4242
> ------------------------------------------------------------------------
> pvautour_4242's Profile:
> http://www.excelforum.com/member.php...o&userid=33972
> View this thread: http://www.excelforum.com/showthread...hreadid=537468
>