Calculate total sum based on different rate

Hi - I need help on attached spreadsheet.

I'm trying to populate total/sum of salary for a group of people at column B based on working hours at column A. The rate is 350 for the 1st 2 hours and 150 for every subsequent hours.
I am struggling to find the formula in. Could someone help?

i think this works.. try this .. a bit clunky.. but it seems to work..
in B2 put

=IF(A2="","",SUM(IF(A2>=2,2*350,IF(A2<=2,A2*350,"")),IF(A2>=2,SUM(A2-2)*150,IF(A2<=2,IF(A2>=2,2*350,IF(A2<=2,A2-1,""))))))

then copy down

Hi - Thanks for responding!

When i paste the formula the value seems to appear in the lower cell. For example when i paste the formula at B2 the value seems to appear at B3. Weird?

I tried to verify the formula against manual calculation, they dont match.

Originally Posted by xwarlock10x

now im confused.. because 16 hours would be 2 hours at 350 2*350=700 and 14hours at 150 14*150=2100 700+2100=2800...
this formula (=IF(A2="",0,IF(A2<=2,350,350+(A2-2)*150)) gives a result of 2450.00 it dosn't seem to be counting for the second hour only the first.... am i missing something??

ok ok ok.. i just looked again.. you wanted 350 for the first 2 hours NOT 2 hours at 350... sorry. i gave it a try.. lol

Yea its 350 for the first 2 hours. So if 16 hrs;
First 2hrs - 350 = 350
Subsequest hrs - 150*14 = 2100

So > 350 + 2100 = 2450

Thanks for the try. Appreciate that!

Originally Posted by FDibbins

Try this, copied down...
=IF(A2="",0,IF(A2<=2,350,350+(A2-2)*150))

Many thanks buddy, it works as i wanted!

Originally Posted by xlbiznes

Hi,

What is the logic other than you stating that the first 2 hrs the rate is @250 and subsequently @150.

Why can't you simply multiply the first 2 rows with 250 and the rest with 150 ?

If this is not the case, post a sample data with the working to understand your requirement clearly.

It isnt the rows are the variable contributors, its the rate for the first two hrs and subsequent hrs. The sample data was posted initially.
Anyway, i got this solved as you can read through the thread.