| 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 |
| 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 | |||
Threaded Mode
