how to create a formula in excel

  • Thread starter George A. Yorks
  • Start date
G

George A. Yorks

I have created a basic formula @sum(b4+d4+h4+k4+l4+n4) the cells can be
changed at any time. Is there any possible way to have these cell
designations changed simply by selecting the desired cells by use of an
*rather than creating the formula manually each time
 
B

Bob Umlas, Excel MVP

First, use "=" instead of "@"
Next, EITHER replace the "+" inside the formula with ",", OR remove the SUM
function. It's doing double work.
Lastly, you can select the range in the formula, like the k4, and click on
another cell to change the reference.
 
G

George A. Yorks

=ROUNDDOWN((((D4+F4+J4+O4+R4+S4)*3)-72)*0.8,0) This formula will add the six
cells etc. If I change the + to ",", the formula will not calculate. I can
click on a new cell and it will make the change but only in the first
position. Hope I have been clear enough with my explanation
 
E

Earl Kiosterud

George,

you need the + operators if your intention is to add those cells. If you
use a comma, ROUNDDOWN will think you're giving it more arguments, and will
choke.

SUM(D4+F4+J4+O4+R4+S4) will add them up, but the SUM function isn't
necessary since you're explicitly summing them with + operators.
SUM(D4, F4, J4, O4,R4, S4) will add them up, as SUM takes up to 31 (I think)
arguments
 
G

George A. Yorks

Thanks,
I don't know if what I'm trying to do is possible. I want to be able to
change each of the six designated cells by clicking on new cells. I now have
to delete the formula and re-create it. If I use ,", instead of + I can
change the first designated cell by clicking a new one. Will not however
move to each of the remaining letters and as you have said will not add.
Does this make sense as I've written it??
 
E

Earl Kiosterud

George,

If you put the formula into edit mode (double-click or press F2), then the
colored reference boxes that appear can be dragged around to change the cell
references. Perhaps that would be suitable.

To be able to click them would probably require some event-driven macros.
 
Top