| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Replace all negatives in a column with zero
Hi,
I need to replace all negatives in a column with zero. I'm running into a problem because one, not all numbers in that column are negative, and two, I already have functions that have to stay in the cells. Is there anything that I can do with formatting or can I have more than one function in a cell...and if so, what function? Thanks!!! |
|
#2
|
|||
|
|||
Give us an example of the functions you have in the cells. The functions or
formulas from 3 consecutive cells should help us know if this is to be easy or not. Example, if your formula is simply able to be copied down, but produces negative numbers, then n your first cell with a formula, replace your_formula with =MAX(0,your_formula) and then just copy down. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "Laura@Gage" wrote in message ... Hi, I need to replace all negatives in a column with zero. I'm running into a problem because one, not all numbers in that column are negative, and two, I already have functions that have to stay in the cells. Is there anything that I can do with formatting or can I have more than one function in a cell...and if so, what function? Thanks!!! -- Laura@Gage |
|
#3
|
|||
|
|||
|
One way might be to use a helper col,
then point all downstream calcs to it If orig. col is col A, with data/formulas in row2 down Put in B2: =MAX(A2,0) Copy B2 down -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "Laura@Gage" wrote in message ... Hi, I need to replace all negatives in a column with zero. I'm running into a problem because one, not all numbers in that column are negative, and two, I already have functions that have to stay in the cells. Is there anything that I can do with formatting or can I have more than one function in a cell...and if so, what function? Thanks!!! -- Laura@Gage |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I sort by row instead of by column? | Excel Worksheet Functions | |||
| Format cell in column B based on value in the next cell (column c) | Excel Discussion (Misc queries) | |||
| Copying the contents of a column into a chart | Excel Worksheet Functions | |||
| How to calculate the data in excel 2002 including only the last 9. | Excel Worksheet Functions | |||
| How to Replace numbers and text with numbers only? | Excel Worksheet Functions | |||
Linear Mode
