| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to identify a keyword in all cells of a column | Excel Discussion (Misc queries) | |||
| Need one formula for large sections of one column, but.... | Excel Discussion (Misc queries) | |||
| Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
| Formula to compare multiple rows values based on another column? | Excel Worksheet Functions | |||
| how to enter a formula using column() function for a range | Excel Worksheet Functions | |||
Linear Mode
