If Then formula. If false, I would like to leave the cell blank.

**joaquinwalking** · 07-30-2013, 01:42 PM

For a false condition I would like to leave the cell blank. I'm using 0 (the number zero) now, but that writes 0 in the cell, which I don't want.

Thanks,

joaquinwalking

**wfm007** · 07-30-2013, 01:45 PM

Use as following example:

Please Login or Register  to view this content.

"" is for blank

**joaquinwalking** · 07-30-2013, 01:51 PM

Beautiful!!! Thank-you very much!

**joaquinwalking** · 07-30-2013, 01:52 PM

Sorry I forgot the stars. Here you go *********.

**wfm007** · 07-30-2013, 01:56 PM

You are welcome

You can add * by clicking on "Add Reputation" on my solution thread.

If Then formula. If false, I would like to leave the cell blank.

LinkBack

Thread Tools

Rate This Thread

Display

If Then formula. If false, I would like to leave the cell blank.

Re: If Then formula. If false, I would like to leave the cell blank.

Re: If Then formula. If false, I would like to leave the cell blank.

Re: If Then formula. If false, I would like to leave the cell blank.

Re: If Then formula. If false, I would like to leave the cell blank.

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Leave a cell with a formula blank until another is filled in

Formula to leave a cell blank

Question: How do I leave a cell blank if formula value is #N/A

False - want to leave blank

[SOLVED] Formula <0 leave cell blank

Bookmarks

Bookmarks

Posting Permissions