Is there a way to return either a number or a blank cell?

**mumair** · 06-21-2017, 11:57 AM

Right now I have a simple function

Please Login or Register  to view this content.

This obviously returns a number. However, I dragged this formula down a spreadsheet where a user has to enter data in columns A and B. If there is no data in column B, the cell returns an error (dividing by zero). I worked around this somewhat by using the following function

Please Login or Register  to view this content.

This would return a zero if there is no data entered in column B. This is better, but not perfect. What I really want is a function that will either return the correct number or a blank cell. Is there a way to do this without using VBA?

**Raphaelp** · 06-21-2017, 12:03 PM

=iferror(a1/b1, "")

**Xandler** · 06-21-2017, 12:03 PM

If I understand correctly, you want it to return a blank cell and NOT a 0 (zero), if that's the case just replace the 0 with "" like so:

=IFERROR(A1/B1,"")

**mumair** · 06-21-2017, 12:35 PM

Thanks guys, simple enough

Is there a way to return either a number or a blank cell?

LinkBack

Thread Tools

Rate This Thread

Display

Is there a way to return either a number or a blank cell?

Re: Is there a way to return either a number or a blank cell?

Re: Is there a way to return either a number or a blank cell?

Re: Is there a way to return either a number or a blank cell?

Thread Information

Users Browsing this Thread

Similar Threads

Return first non blank cell (cells have formulas that return blank)

[SOLVED] return number from column if number is greater than and return result from different cell.

[SOLVED] multiple if and vlookups, return number or blank cell

[SOLVED] Cell referenced in formula has no information displayed (shows blank), return blank cell

[SOLVED] Return row number of blank row

If a cell is blank(not zero) return 0 if it is a number or 0 return 10?

Return number from no blank cell

Bookmarks

Bookmarks

Posting Permissions