multiple function in formula

[Mel B]

Hey guys
How can I make the following formula work =(B3+C3+D3)*E3*F3? I need the
numbers in brackets to be multiplied by E3 and then that number multiplied by
F3, what am I doing wrong?
Thanks
Mel

 

[Gary]

Try this

=(((B3+C3+D3)*(E3))*(F3))

let me know if it works.

Thanks
Gary

 

[Mel B]

Hi Gary
Thanks for this, alas it didn't work the answer I get is 2 decimal
places out i.e. 4.14875 as opposed to 414.875 and has "E+12" on the end.....?
Mel

 

[Gary]

Try changing the format by right clicking on the cell.

or

can you tell me the numbers u have in B3,C3,D3,E3 AND F3?

 

[Ron Rosenfeld]

Hey guys
How can I make the following formula work =(B3+C3+D3)*E3*F3? I need the
numbers in brackets to be multiplied by E3 and then that number multiplied by
F3, what am I doing wrong?
Thanks
Mel

Give some sample data, expected and actual results.

For example =(1+2+3)*4*5 --> 120

What result do you expect?


--ron

 

[MartinW]

Hi Mel,

There is nothing wrong with your formula, it works just fine as is.
It sounds like you are getting a very large number from it.
Excel only handles numbers up to 15 digits. After that
it just adds zeroes, that's what the E+12 is all about.
Whatever the number is move the decimal point
12 places to the right substituting zeroes after you
run out of numbers.

HTH
Martin

 

[patele]

Mel,

You're on the right track. Try this

=SUM($B$3:$D$3)*E3*F3

 

[Mel B]

B3 = 30310239.67 C3 = 3 D3 = 0 E3 = 0.0672 F3 = 2036848.11

 

[Gary]

4148750625333.27


this is what you should get after changing the format to number and setting
the decimal plces to 2.

is this what u wanted?

 

[Mel B]

Thanks Ron. I've just spoken with the person I'm doing this formula
for....and he's given me the totally wrong information! ARGH!!! thanks for
your help anyway

 

[Mel B]

Thanks Patele. I've just spoken with the person I'm doing this formula
for....and he's given me the totally wrong information! ARGH!!! thanks for
your help anyway

 

[Mel B]

Thanks Martin. I've just spoken with the person I'm doing this formula
for....and he's given me the totally wrong information! ARGH!!! thanks for
your help anyway
Thanks for the info on the large number (E+12) deal too, I didn't realise
that!