multiple function in formula

M

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
 
M

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
 
G

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?
 
R

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
 
M

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
 
G

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?
 
M

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 :)
 
M

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 :)
 
M

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top