Can't make the division work in my formula

[jeannie v]

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.

 

[Tyro]

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

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,

 

[Tyro]

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
thank you for explaining it to me...I truly appreciate your expertise and
your tolerance.

Thank you,