| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need formula to change cells from negative numbers to a zero.
I am creating a work sheet with several different formulas in it (all
accounting formulas) and after entering numbers into other cells it changes some of the other cells to have a negative balance. OK, so I need to know if there is a formula that I can enter into certain cells that will change any negative balance no matter what it may be from showing the negative balance to showing a zero (0) instead? Does anyone know how to do this or have any suggestions on how I could find out? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Need formula to change cells from negative numbers to a zero.
Use the MAX function coupled with your formula...
=MAX(0,<YourFormula) -- Rick (MVP - Excel) "CPS Nevada" <CPS wrote in message ... I am creating a work sheet with several different formulas in it (all accounting formulas) and after entering numbers into other cells it changes some of the other cells to have a negative balance. OK, so I need to know if there is a formula that I can enter into certain cells that will change any negative balance no matter what it may be from showing the negative balance to showing a zero (0) instead? Does anyone know how to do this or have any suggestions on how I could find out? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Need formula to change cells from negative numbers to a zero.
Try this:
=MAX(0,your_formula) If your_formula produces a negative value then this will return zero, but if your_formula is positive then that is larger than 0 and so gets returned. Hope this helps. Pete On Feb 10, 11:59*pm, CPS Nevada <CPS wrote: I am creating a work sheet with several different formulas in it (all accounting formulas) and after entering numbers into other cells it changes some of the other cells to have a negative balance. OK, so I need to know if there is a formula that I can enter into certain cells that will change any negative balance no matter what it may be from showing the negative balance to showing a zero (0) instead? Does anyone know how to do this or have any suggestions on how I could find out? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to change positive numbers to negative numbers without re-ente | Excel Worksheet Functions | |||
| Excel, change column of negative numbers to positive numbers? | New Users to Excel | |||
| CHANGE A ROW OF POSTIVE NUMBERS TO NEGATIVE NUMBERS | Excel Discussion (Misc queries) | |||
| change 2000 cells (negative numbers) into positive numbers | Excel Worksheet Functions | |||
| How to change a series of positive numbers to negative numbers | Excel Worksheet Functions | |||
Hybrid Mode
