help my formula to recalculate hourly wage with a minumum charge and it doesnt add up

[sera]

I havent used excel in years, would really like someone to have a look and see how I can fix my totals. One is without a $50.00 minimum day charge one is with. The formula I used to calculate my formula with the minimum charge was an IF query. Im thinking thats where my problem lies.

= IF((SUM(D26*$B$3)*24 )>50,"","$50.00"))

Anyway if someone has anything that could help please let me know.
I obviously dont need all the columns but just wanted to show my workings

thanks in advance

Sera

 

[Hui]

All your calculations are correct

I would make the following small changes
D13: =C13-B13
E13: =D13*$B$3*24
F13: =MAX(E13,50)
G13: =F13-E13
Copy D13:G13 down
There is no need to start calculations with =Sum()
Formula simply need an = to tell Excel that it is a formula

See attached File:

ps: Your not out it adds up precisely to 2 Decimal places

 

[sera]

Thanks very much Hui, Im off to work but will have a better look when I get home. Thankyou

 

[sera]

wow that is great advice thankyou so much. I love that its so simple I think I went the long long way around lol.

 

[Somendra Misra]

@sera

Though you got a great way by @Hui ,here's my comment to just tell you that you are giving result a text of "$50.00" when formula logic is FALSE, now after that you are trying subtracting a number with a text so you are getting an #Value error. Instead use only 50 and than custom format it to currency, that way your formula will start working.

2nd drop all the SUM for all the formula's.

See the attached file for working.

Regards,