Is this right? if not please explain
1 answer:
You might be interested in
Full question attached:
Answer and explanation:
A) B2*B10: cell B2 and B10 have the values regular swear costs and number of swears respectively and we need to multiply these two values to get our answer
B) =IF(B10>10,(B10-10)*B3,0): Sam is supposed to pay an extra $2 for swear words over 10 and so we check if his swear words are above 10 and if they are we find out how many they are by subtracting 10 from them and then we multiply the value gotten by the cost for extra swear words($2)
C) =IF(B10<5,B10*B4,0): here we check if swear words are less than 5 and if they are we multiply number of swears words less than by 5 by the cost ($0.50)
D) F10=C10+D10+E10: to calculate total money in jar(F10), we simply add up regular cost(C10), extra cost(D10) and refund(E10)
