Thread: help please with simple formula

F4 i have 0
H4 i have 6
J4 i have 1.12
The answer in N4 is 6 (good enough but would like to round to nearest No
which should be 7)
Formula used is =H4-F4*J4

F7 i have 0
H7 i have 6
J7 i have 2.24
The answer in N7 is still 6 ( it should be 12, double the one above)
Formula used is =H7-F7*J7

just can`t work this out.

help please
thanks

Scudo wrote:
> F4 i have 0
> H4 i have 6
> J4 i have 1.12
> The answer in N4 is 6 (good enough but would like to round to nearest No
> which should be 7)
> Formula used is =H4-F4*J4
>
> F7 i have 0
> H7 i have 6
> J7 i have 2.24
> The answer in N7 is still 6 ( it should be 12, double the one above)
> Formula used is =H7-F7*J7
>
> just can`t work this out.
>
> help please
> thanks
>
>
the multiplcation takes place first thus for the first formula you
have 6- 0, zero times anything is zero. This applies to the second
formula also. Try (H7-F7)*J7

If you wnat it rounded try the Round function

gls858

You need some parens, Scudo:
=(H4-F4)*J4
What it's doing now is taking H4-(F4*J4)
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Scudo" <me@nospam.fictional> wrote in message
news:ujfze.6154$O22.3777@fe1.news.blueyonder.co.uk...
> F4 i have 0
> H4 i have 6
> J4 i have 1.12
> The answer in N4 is 6 (good enough but would like to round to nearest No
> which should be 7)
> Formula used is =H4-F4*J4
>
> F7 i have 0
> H7 i have 6
> J7 i have 2.24
> The answer in N7 is still 6 ( it should be 12, double the one above)
> Formula used is =H7-F7*J7
>
> just can`t work this out.
>
> help please
> thanks
>
>

Sorry, Scudo. Rounding:

http://www.officearticles.com/excel/...soft_excel.htm

*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Anne Troy" <ng@officearticles.com> wrote in message
news:406ca$42cd8525$97c5108d$11996@allthenewsgroups.com...
> You need some parens, Scudo:
> =(H4-F4)*J4
> What it's doing now is taking H4-(F4*J4)
> *******************
> ~Anne Troy
>
> www.OfficeArticles.com
> www.MyExpertsOnline.com
>
>
> "Scudo" <me@nospam.fictional> wrote in message
> news:ujfze.6154$O22.3777@fe1.news.blueyonder.co.uk...
> > F4 i have 0
> > H4 i have 6
> > J4 i have 1.12
> > The answer in N4 is 6 (good enough but would like to round to nearest
No
> > which should be 7)
> > Formula used is =H4-F4*J4
> >
> > F7 i have 0
> > H7 i have 6
> > J7 i have 2.24
> > The answer in N7 is still 6 ( it should be 12, double the one above)
> > Formula used is =H7-F7*J7
> >
> > just can`t work this out.
> >
> > help please
> > thanks
> >
> >
>
>

Thanks again to all for help, my problem (s) are now sorted.

regards
Scudo

"Anne Troy" <ng@officearticles.com> wrote in message
news:e8e0e$42cd899d$97c5108d$26641@allthenewsgroups.com...
> Sorry, Scudo. Rounding:
>
>
http://www.officearticles.com/excel/..._microsoft_exc
el.htm
>
> *******************
> ~Anne Troy
>
> www.OfficeArticles.com
> www.MyExpertsOnline.com
>
>
> "Anne Troy" <ng@officearticles.com> wrote in message
> news:406ca$42cd8525$97c5108d$11996@allthenewsgroups.com...
> > You need some parens, Scudo:
> > =(H4-F4)*J4
> > What it's doing now is taking H4-(F4*J4)
> > *******************
> > ~Anne Troy
> >
> > www.OfficeArticles.com
> > www.MyExpertsOnline.com
> >
> >
> > "Scudo" <me@nospam.fictional> wrote in message
> > news:ujfze.6154$O22.3777@fe1.news.blueyonder.co.uk...
> > > F4 i have 0
> > > H4 i have 6
> > > J4 i have 1.12
> > > The answer in N4 is 6 (good enough but would like to round to
nearest
> No
> > > which should be 7)
> > > Formula used is =H4-F4*J4
> > >
> > > F7 i have 0
> > > H7 i have 6
> > > J7 i have 2.24
> > > The answer in N7 is still 6 ( it should be 12, double the one
above)
> > > Formula used is =H7-F7*J7
> > >
> > > just can`t work this out.
> > >
> > > help please
> > > thanks
> > >
> > >
> >
> >
>
>

Scudo wrote:
> Thanks again to all for help, my problem (s) are now sorted.
>
> regards
> Scudo
>
> "Anne Troy" <ng@officearticles.com> wrote in message
> news:e8e0e$42cd899d$97c5108d$26641@allthenewsgroups.com...
>
>>Sorry, Scudo. Rounding:
>>
>>
>
> http://www.officearticles.com/excel/..._microsoft_exc
> el.htm
>
>>*******************
>>~Anne Troy
>>
>>www.OfficeArticles.com
>>www.MyExpertsOnline.com
>>
>>
>>"Anne Troy" <ng@officearticles.com> wrote in message
>>news:406ca$42cd8525$97c5108d$11996@allthenewsgroups.com...
>>
>>>You need some parens, Scudo:
>>>=(H4-F4)*J4
>>>What it's doing now is taking H4-(F4*J4)
>>>*******************
>>>~Anne Troy
>>>
>>>www.OfficeArticles.com
>>>www.MyExpertsOnline.com
>>>
>>>
>>>"Scudo" <me@nospam.fictional> wrote in message
>>>news:ujfze.6154$O22.3777@fe1.news.blueyonder.co.uk...
>>>
>>>>F4 i have 0
>>>>H4 i have 6
>>>>J4 i have 1.12
>>>>The answer in N4 is 6 (good enough but would like to round to
>
> nearest
>
>>No
>>
>>>>which should be 7)
>>>>Formula used is =H4-F4*J4
>>>>
>>>>F7 i have 0
>>>>H7 i have 6
>>>>J7 i have 2.24
>>>>The answer in N7 is still 6 ( it should be 12, double the one
>
> above)
>
>>>>Formula used is =H7-F7*J7
>>>>
>>>>just can`t work this out.
>>>>
>>>>help please
>>>>thanks
>>>>
>>>>
>>>
>>>
>>
>
>
Glad you got it sorted.
Thanks for posting back.

gls858

Dear Scudo

I think it's now been answered, but remember in general that excel follows
mathematical conventions. eg BODMAS (easy to remember) -- formualae are resolved
in the strict order: * Brackets Of Divide Multiply Add Subtract*. So if you want
to add or subtract *before* multiplying/dividing then you must use brackets round
the items to first be added/subtracted.

eg 4 X 5-1 = 19 -- multiplies first then subtracts
but 4 X (5-1) = 16 -- does what's in the brackets first then multiplies



gls858 wrote:

> >>>>F7 i have 0
> >>>>H7 i have 6
> >>>>J7 i have 2.24
> >>>>The answer in N7 is still 6 ( it should be 12, double the one
> > above)
> >>>>Formula used is =H7-F7*J7
> >>>>
> >>>>just can`t work this out.
> >>>>
> >>>>help please
> >>>>thanks