Replace number signe with a zero

**Khaldon** · 03-23-2015, 10:06 AM

When my formula generates a negative number, it will I have a number signs (###) in the cell.

How can I please replace the number signe (###) with a zero (0) if my following formula resulted in a nigtive number:

=L60-(C62+E62)

**Jonmo1** · 03-23-2015, 10:07 AM

Try

=MAX(0,L60-(C62+E62))

**bebo021999** · 03-23-2015, 10:11 AM

Are those cells date?

=IF(L60>(C62+E62),L60-(C62+E62),0)

**Khaldon** · 03-23-2015, 10:12 AM

It is times hh:mm

Replace number signe with a zero

LinkBack

Thread Tools

Rate This Thread

Display

Replace number signe with a zero

Re: Replace number signe with a zero

Re: Replace number signe with a zero

Re: Replace number signe with a zero

Thread Information

Users Browsing this Thread

Similar Threads

Find a number and replace the adjacent cell with other number

[SOLVED] Replace text number with some other number based on the sheet

[SOLVED] Compare columns, replace matching number with reference number and fill down random amount

Replace C with A when C is followed by a number, but not otherwise?

How do I replace a negative number with zero

Bookmarks

Bookmarks

Posting Permissions