| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
cell to show ' 0 ' , or nothing at all, if the sum is a negative number
I'm making a worksheet for my company. I want to subtract one number number from another number. I use the 'sum' format for this '=sum(BL4-BP4) '. This format works fine for me in most cases, if BL4 BP4. However, if BL4<BP4, the sum that is shown is a negative number. I would like for the worksheet to show only positive numbers. I would like for the cell to show ' 0 ' , or nothing at all, if the sum is a negative number. For instance, 10-8=12 is ok, but 8-10=-2 is not. How do I do this? Thanks -- rdmdale ------------------------------------------------------------------------ rdmdale's Profile: http://www.excelforum.com/member.php...o&userid=27339 View this thread: http://www.excelforum.com/showthread...hreadid=468481 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
| How to show a leading 0 in a cell. | Excel Discussion (Misc queries) | |||
| Problem with IF condition or vector lookup? | Excel Worksheet Functions | |||
| Show Blank is cell value=0 but count as a zero in sum. How to format this cell ? | Excel Worksheet Functions | |||
| cell reference show cell name (ie. D45) and not cell value | Excel Worksheet Functions | |||
Threaded Mode
