View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jeannie v jeannie v is offline
external usenet poster
 
Posts: 127
Default 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