View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default Divide within the same cell

hi
put your what you want to devide in parenthesis ie
=((C19*C1)+(D19*D1)+(E19*E1))/F1
in this way the (C19*C1)+(D19*D1)+(E19*E1) portion of your formula will be
calculated first then treated as a single number.

regards
FSt1

"RJ Swain" wrote:

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..