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

Try this

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

let me know if it works.

Thanks
Gary

"Mel B" <Mel wrote in message
...
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

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" wrote:

Try this

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

let me know if it works.

Thanks
Gary

"Mel B" <Mel wrote in message
...
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

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?


"Mel B" wrote in message
...
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" wrote:

Try this

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

let me know if it works.

Thanks
Gary

"Mel B" <Mel wrote in message
...
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

On Mon, 17 Jul 2006 02:48:01 -0700, Mel B <Mel
wrote:

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

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

Mel,

You're on the right track. Try this

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


--
patele
------------------------------------------------------------------------
patele's Profile: http://www.excelforum.com/member.php...o&userid=35849
View this thread: http://www.excelforum.com/showthread...hreadid=561978

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

"Gary" wrote:

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?


"Mel B" wrote in message
...
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" wrote:

Try this

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

let me know if it works.

Thanks
Gary

"Mel B" <Mel wrote in message
...
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

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" wrote in message
...
B3 = 30310239.67 C3 = 3 D3 = 0 E3 = 0.0672 F3 = 2036848.11

"Gary" wrote:

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?


"Mel B" wrote in message
...
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" wrote:

Try this

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

let me know if it works.

Thanks
Gary

"Mel B" <Mel wrote in message
...
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

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

"Ron Rosenfeld" wrote:

On Mon, 17 Jul 2006 02:48:01 -0700, Mel B <Mel
wrote:

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

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

"patele" wrote:


Mel,

You're on the right track. Try this

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


--
patele
------------------------------------------------------------------------
patele's Profile: http://www.excelforum.com/member.php...o&userid=35849
View this thread: http://www.excelforum.com/showthread...hreadid=561978

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!

"MartinW" wrote:

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