| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Making negative numbers show as zero.
how do I make a cell show zero if the number is negative? Excel help doesn't have this info in a redily available place. -- GregP1962 ------------------------------------------------------------------------ GregP1962's Profile: http://www.excelforum.com/member.php...o&userid=33063 View this thread: http://www.excelforum.com/showthread...hreadid=528761 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Making negative numbers show as zero.
If your cell gives negative values due to a formula try this: =if(FORMULA IN CELL<0,0,FORMULA IN CELL) -- renegan ------------------------------------------------------------------------ renegan's Profile: http://www.excelforum.com/member.php...o&userid=10450 View this thread: http://www.excelforum.com/showthread...hreadid=528761 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Making negative numbers show as zero.
Use a custom format (Cells(FormatCustom) of
General;"0";General -- HTH Bob Phillips (remove nothere from email address if mailing direct) "GregP1962" wrote in message ... how do I make a cell show zero if the number is negative? Excel help doesn't have this info in a redily available place. -- GregP1962 ------------------------------------------------------------------------ GregP1962's Profile: http://www.excelforum.com/member.php...o&userid=33063 View this thread: http://www.excelforum.com/showthread...hreadid=528761 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Making negative numbers show as zero.
If your cell gives negative values due to a formula try this: =if(FORMULA IN CELL<0,0,FORMULA IN CELL) -- renegan ------------------------------------------------------------------------ renegan's Profile: http://www.excelforum.com/member.php...o&userid=10450 View this thread: http://www.excelforum.com/showthread...hreadid=528761 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Making negative numbers show as zero.
renegan Wrote: If your cell gives negative values due to a formula try this: =if(FORMULA IN CELL<0,0,FORMULA IN CELL) ...or =MAX(0,formula) -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=528761 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Making negative numbers show as zero.
I used the first one. Thanks! =if(FORMULA IN CELL<0,0,FORMULA IN CELL) -- GregP1962 ------------------------------------------------------------------------ GregP1962's Profile: http://www.excelforum.com/member.php...o&userid=33063 View this thread: http://www.excelforum.com/showthread...hreadid=528761 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Making negative numbers show as zero.
Are these numbers the result of a formula? If so, then you can use the MAX()
function. =MAX(0,yourformula) This displays the larger of the two numbers, so if your formula results in a negative number, the 0 will be larger and thus be displayed. HTH, Elkar "GregP1962" wrote: how do I make a cell show zero if the number is negative? Excel help doesn't have this info in a redily available place. -- GregP1962 ------------------------------------------------------------------------ GregP1962's Profile: http://www.excelforum.com/member.php...o&userid=33063 View this thread: http://www.excelforum.com/showthread...hreadid=528761 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Making negative numbers show as zero.
On Fri, 31 Mar 2006 15:12:32 -0800, Elkar
wrote: Are these numbers the result of a formula? If so, then you can use the MAX() function. =MAX(0,yourformula) This displays the larger of the two numbers, so if your formula results in a negative number, the 0 will be larger and thus be displayed. It will also change the results of any calculations that in turn depend on this cell. If this is what you want, fine. Alternatively, if you only want negtive numbers to DISPLAY as zero, use a custom format (as shown in an earlier response). This won't cause numeric values to change. "GregP1962" wrote: how do I make a cell show zero if the number is negative? Excel help doesn't have this info in a redily available place. -- GregP1962 ------------------------------------------------------------------------ GregP1962's Profile: http://www.excelforum.com/member.php...o&userid=33063 View this thread: http://www.excelforum.com/showthread...hreadid=528761 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to show all the possible combination of a set of numbers? | Excel Worksheet Functions | |||
| convert negative numbers to positive numbers and vice versa | Excel Worksheet Functions | |||
| How to change a series of positive numbers to negative numbers | Excel Worksheet Functions | |||
| Can I calculate negative numbers to = zero in excel? | Excel Discussion (Misc queries) | |||
| how do I rank negative and positive numbers? | Excel Worksheet Functions | |||
Hybrid Mode
