If sum is negative, how do I create a blank cell.

**Heath3rly** · 10-21-2016, 05:09 PM

Hello!

This is my first time posting so I'd just like to just say that I'm pretty new to excel and self taught. I'm working with time and have formatted my cells in the [h]:mm:ss. I was having an issue with subtracting so I have put some data on on Sheet2. I'm trying to subtract 0:02:00.

So my real issue is I need any negative values, showing as #####, to show as blank or zero. I haven't had any luck so far.

Please Login or Register  to view this content.

Thanks to anyone who is able to help!

**Tony Valko** · 10-21-2016, 05:16 PM

Maybe this to return 0:

=MAX(0,IF(C28>W28, C28-W28, "0:00:00")+(M28-Sheet2!A2))

**Heath3rly** · 10-21-2016, 05:23 PM

Wow, yes! Thank you so much for your help Tony

**Tony Valko** · 10-21-2016, 05:42 PM

You're welcome. Thanks for the feedback!

If sum is negative, how do I create a blank cell.

LinkBack

Thread Tools

Rate This Thread

Display

If sum is negative, how do I create a blank cell.

Re: If sum is negative, how do I create a blank cell.

Re: If sum is negative, how do I create a blank cell.

Re: If sum is negative, how do I create a blank cell.

Thread Information

Users Browsing this Thread

Similar Threads

Create a BLANK cell If zero's

[SOLVED] Formula to create a blank cell based on a dollar amount in another cell.

Create Quarter/Year Field, but if blank, either populate cell with ERROR or leave blank

How to delete cells (i.e. make a blank cell) if numbers are negative

If/Then Forumla to create blank cell???

[SOLVED] display negative values as a blank cell in Excel

display negative values as a blank cell in Excel

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions