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
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 [email protected]> wrote in message
news:[email protected]...
> 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 [email protected]> wrote in message
> news:[email protected]...
> > 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" <[email protected]> wrote in message
news:[email protected]...
> 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 [email protected]> wrote in message
>> news:[email protected]...
>> > 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
>>
>>
>>
Mel,
You're on the right track. Try this
=SUM($B$3:$D$3)*E3*F3
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
On Mon, 17 Jul 2006 02:48:01 -0700, Mel B <Mel [email protected]>
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
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" <[email protected]> wrote in message
> news:[email protected]...
> > 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 [email protected]> wrote in message
> >> news:[email protected]...
> >> > 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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
>> news:[email protected]...
>> > 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 [email protected]> wrote in message
>> >> news:[email protected]...
>> >> > 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 [email protected]>
> 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
>
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks