ExcelBanter - formula for a column

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - formula for a column (https://www.excelbanter.com/excel-discussion-misc-queries/39212-formula-column.html)

msdobe

formula for a column

I'm working on a daily worksheet where all the values for a column will be
the same

ex. L2/C2, L3/C3, L4/C4

How do I set it up?

Max

Assuming the column you want to compute the values
is in say, col M

Put in M2: =IF(C2=0,"",L2/C2)
and press ENTER

Point the cursor to the bottom right corner of M2
(cursor will turn into a "black cross")

Drag to fill as far down as required ..
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"msdobe" wrote in message
...
I'm working on a daily worksheet where all the values for a column will be
the same

ex. L2/C2, L3/C3, L4/C4

How do I set it up?

All times are GMT +1. The time now is 06:38 AM.