Solved Excel - automatic copy formulae on data entry

September 6, 2013 at 20:29:55
Specs: Windows 7
I have a table with several simple formulae in it, that sum data across a row.
Currently, I use the "Copy Down" function, but that produces several rows of zeros in the various columns where there is no data to compute.
Is there a way of entering data in, say column 1, that will invoke the formulae onto the current line, so I can have an aesthetic spreadsheet that expands as I enter data?
I tried to add a JPG that explains visually what I want, but the system wouldn't accept it. Sorry

message edited by happywanderer


See More: Excel - automatic copy formulae on data entry

Report •


#1
September 7, 2013 at 06:22:27
You could wrap your sum formula in an IF() statement so if a cell is blank, the sum formula does not calculate.

Something like:

=IF(A1="","",SUM(A1*B1))

There is even an Excel Function, called ISBLANK()

=IF(ISBLANK(A1),"",F1/G1)

MIKE

http://www.skeptic.com/


Report •

#2
September 7, 2013 at 07:54:15
✔ Best Answer
There are also a number of other ways to hide zero values as described at the link below. Examples include setting worksheet options, using conditional formatting, formulas, etc.

http://office.microsoft.com/en-us/e...

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question