| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I change all negative values in a column to = 0?
I'm trying to calculate an average of data, but need to ignore negative
numbers in the range from which I'm taking the average. I'd like to either format cells to calculate based on displayed values rather than actual values OR use something like an IF function to change negative values into zeros or NA. I would much appreciate any help on this. Thx! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| I Need a formula to evaluate a cell with + or - values | Excel Worksheet Functions | |||
| creating a bar graph | Excel Discussion (Misc queries) | |||
| how do i sum up a column of time values but ignore negative values | New Users to Excel | |||
| Pbl calculating US$ values | Excel Discussion (Misc queries) | |||
Threaded Mode
