| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Make table query will work in datasheet view but will not make tab | Excel Discussion (Misc queries) | |||
| Urgent - make formula work with both decimal separators | Excel Discussion (Misc queries) | |||
| one formula to make a multiplication table work | Excel Worksheet Functions | |||
| division formula | New Users to Excel | |||
| How do I make this formula work =if(a1=(b10:b20),"good","bad"). | Excel Worksheet Functions | |||
Linear Mode
