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