Can't make the division work in my formula

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jeannie v - 07 Mar 2008 17:49 GMT

Hi Experts:

All I want to do in Cell B7 on a worksheet is take 38 on a separate
worksheet in B28 and subtract 11 on a different worksheet in E5 and then
divide it by 2 with the result returned in Cell B7...Seems simple
enough...don't know what I have wrong in the formula...

In "Overview" Cell B7
=SUM('Crosstree'!$B$28)-('Previous Day!$E5)/2

Can someone please help me? Thank you for your expertise.

Signature

jeannie v

Reply to this Message

Tyro - 07 Mar 2008 17:56 GMT

=(Crosstree!$B$28-'Previous Day'!$E5)/2

The parentheses are necessary to ensure the subtraction is done before the
division. Division has precedence over subtraction. The single quotes around
Previous Day are necessary because the sheet name has a space in it. There
is no need for single quotes around Crosstree as there is no space. There is
no need to use the SUM function.

Tyro

> Hi Experts:
>
[quoted text clipped - 7 lines]
>
> Can someone please help me? Thank you for your expertise.

Reply to this Message

jeannie v - 07 Mar 2008 18:11 GMT

Evidently it was quite simple...I was making it harder than it needed to
be....I've tested your resolution and it works perfectly....I also want to
thank you for explaining it to me...I truly appreciate your expertise and
your tolerance.

Thank you,

Signature

jeannie v

> =(Crosstree!$B$28-'Previous Day'!$E5)/2
>
[quoted text clipped - 17 lines]
> >
> > Can someone please help me? Thank you for your expertise.

Reply to this Message

Tyro - 07 Mar 2008 18:18 GMT

You're welcome

Tyro

> Evidently it was quite simple...I was making it harder than it needed to
> be....I've tested your resolution and it works perfectly....I also want to
[quoted text clipped - 29 lines]
>> >
>> > Can someone please help me? Thank you for your expertise.

Reply to this Message