Creat a formula for multiplying a formula

K

Kylie Rose

Someone on this site was kind enough to give me the following formula:

=LOOKUP(A1,{0,"";1,50;2,100;3,120})

Now however I need to multiply the formula contained in this cell by a
number entered into another cell in the same row.

So say A1 = People, B1 = Days, C1 = Above formula (calculating cost for the
amount of people, D1 needs to = the price for that amount of people for that
amount of days, I tried =SUM(B1*C1), obviously easy is not the best choice,
all I get is #VALUE! and after trying the suggested remedies I've had no luck.

Thank you to anyone taking the time to answer this! :) Kylie
 
J

jnurse

Hi Kylie,

Just keep it simple with the multiplication operator (=B1*C1) or if you're
using a function, try =PRODUCT(B1,C1).
 
Top