Can't make the division work in my formula
 

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.

--
jeannie v

Can't make the division work in my formula
 

=(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


"jeannie v" wrote in message
...
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.

--
jeannie v

Can't make the division work in my formula
 

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,
--
jeannie v


"Tyro" wrote:

=(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


"jeannie v" wrote in message
...
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.

--
jeannie v

Can't make the division work in my formula
 

You're welcome

Tyro

"jeannie v" wrote in message
...
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,
--
jeannie v


"Tyro" wrote:

=(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


"jeannie v" wrote in message
...
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.

--
jeannie v