Results 1 to 9 of 9

Excel does not return a DIV/0 error although a cell is blank

Threaded View

guusb99 Excel does not return a DIV/0... 05-08-2023, 11:27 AM
sandy666 Re: Excel does not return a... 05-08-2023, 11:29 AM
AliGW Re: Excel does not return a... 05-08-2023, 11:30 AM
guusb99 Re: Excel does not return a... 05-08-2023, 11:37 AM
Glenn Kennedy Re: Excel does not return a... 05-08-2023, 11:33 AM
AliGW Re: Excel does not return a... 05-08-2023, 11:41 AM
guusb99 Re: Excel does not return a... 05-08-2023, 11:44 AM
AliGW Re: Excel does not return a... 05-08-2023, 11:45 AM
FlameRetired Re: Excel does not return a... 05-08-2023, 12:00 PM
  1. #1
    Registered User
    Join Date
    05-08-2023
    Location
    Utrecht, Netherlands
    MS-Off Ver
    Excel 2021
    Posts
    3

    Excel does not return a DIV/0 error although a cell is blank

    I am trying to calculate a certain score in Excel, with the formula:
    =0,012*(U2/R2)
    Cell U2 contains nothing (blank)
    Cell R2 contains 521993

    Excel does not return an error, but returns a 0. This means that when I extend the formula, a wrong number will be returned. I need an error, just as Excel would normally give you. To enlighten you further, I attached a screenshot below.

    Image1.png

    Hopefully, someone has an idea what is going on. I feel like I am going mad.

    All the best,

    Guus Bronkhorst
    Last edited by guusb99; 05-08-2023 at 11:44 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] I have a formula in excel and want it to return blank if ref cell is blank and not "0"
    By Schwartz_Warehouse in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-22-2021, 03:54 PM
  2. Return first non blank cell (cells have formulas that return blank)
    By BG1983 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-05-2016, 04:06 PM
  3. Replies: 3
    Last Post: 06-19-2015, 02:56 PM
  4. [SOLVED] Getting Excel to return a blank field regardless of cell formatting
    By lukela85 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-26-2013, 03:03 PM
  5. Excel 2007 : IF function to return blank cell
    By jayb in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-15-2013, 04:28 AM
  6. Replies: 2
    Last Post: 09-25-2012, 01:48 PM
  7. Excel formula to return a blank cell
    By MrT in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-18-2006, 04:50 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1