View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
RJ Swain RJ Swain is offline
external usenet poster
 
Posts: 30
Default Divide within the same cell

Is it possible to divide the same number you calculated within the same cell?
here is an example...

=(c19*c1)+(d19*d1)+(e19*e1) is the current formula but what I need to do is
divide this answer with another number within a different cell.

So with that being sad I thought =(c19*c1)+(d19+d1)+(e19*e1)/f1 would work
but it does not it only shows me the sum of the three cell calculations.

F1 has the number in which I need to divide this total by.

Thank you ahead of time for your help..