EXCEL LOGIC PROs HELP needed please...?

Question

THANK YOU ALL IN ADVANCE. I AM NOT THAT GREAT WITH EXCEL. I NEED TO USE THE =if logic.

If something is <50 I would like a certain figure to show up there.

Example if over 50 lbs please add additional .40 cents per lb over 50 lbs. How can I add that and also if wait time is over :15 minutes then add $12.00.

HELP!!!

I am not an excel dummy but I am no wizard either help is needed badly!

Thank you in advance.

5.00 per mile

X 5 miles

+ .40 cents if any lbs. (pounds) over 50 lbs

+ 12.00 if any waiting time over :15 minutes

= TOTAL

Hmmmmm. HELP will be greatly appreciated.

I have gone on exceltip.com and found nothing, it was too advance for me. =if logic is too much for my brain.

Answer 1

Assuming Rate is in A2, Miles is in B2, Pounds is in C2 and Waiting time (in minutes) is in D2 -

=SUM(A2*B2, IF(C2&gt;50, (C2-50)*0.4, 0), IF(D2&gt;15, 12, 0))

Answer 2

it would probably be simpler to use 2 different IF stmts. First, determining the price if over 50 lbs, etc.  Then another to determine if waiting time is over 15 minutes. Then add the 2 results together to get a total cost.

so lets say your weight (50lbs or whatever) is in cell A1

and your waiting time is in B1

in C1 enter

=IF(A1&gt;50, (5*5)+((A1-50)*.40), 5*5)

so if A1 is over 50lbs, we&#039;ll take 5 miles X $5. We&#039;ll also take whatever weight is over 50 lbs (A1-50) X .40/lb and then add 2 together. Otherwise, we&#039;ll just charge the 5X5 amount.

(I would suggest instead of hardcoding the 5 miles and $5 rate, you put those figures in a cell and then reference the cells in the formula)

now in D1 enter

=IF(B1&gt;15, 12, 0)

so if waiting time is over 15 (mins.) then the just put $12 in in D1, otherwise put 0

now in E1

just add the 2 figures =C1+D1

optionally in D1 you could add the waiting charge to the weight charge as well

=IF(B1&gt;15, 12+C1, C1)