+ Reply to Thread
Results 1 to 9 of 9

Dividing cell is giving wrong answer

  1. #1
    Registered User
    Join Date
    08-14-2013
    Location
    Arizona
    MS-Off Ver
    Excel 2007
    Posts
    71

    Dividing cell is giving wrong answer

    Good evening fellow excelers, I'm having an issue with a formula. Simply put, A1=8, B1=A1/2. B1 should display 4, but is showing 0 instead. Doesn't matter where I put the formula in any cell, it still gives the error value of 0. Automatic formulas are turned on, Excel 2013.

    Any thoughts?

    Thank you!

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: Dividing cell is giving wrong answer

    Post your workbook for analysis. Difficult to diagnose with out seeing what is actually happening. Guessing that you may have a text format in A1.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    08-14-2013
    Location
    Arizona
    MS-Off Ver
    Excel 2007
    Posts
    71

    Re: Dividing cell is giving wrong answer

    Not sure what the fix was, but it's working now.

  4. #4
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: Dividing cell is giving wrong answer

    Hi jw,

    It sounds like you have the letter 8 instead of the number 8 in A1. If you type a single quote and then anything else it turns into text. Try this. In another cell put a formula of:
    =IsText(A1)
    If it turns out to be true the type a number 8 into A1 and try your problem again.
    Also look for char(160) in your cells as they look like spaces but aren't
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  5. #5
    Registered User
    Join Date
    08-14-2013
    Location
    Arizona
    MS-Off Ver
    Excel 2007
    Posts
    71

    Re: Dividing cell is giving wrong answer

    Thank you Marvin, but it was a number. Restarted the computer and it's working now. Just a head scratcher I guess.

  6. #6
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: Dividing cell is giving wrong answer

    Look at your AutoCalculate default settings. That is on your formula tab. If set to manual it might have not shows correctly.

  7. #7
    Registered User
    Join Date
    08-14-2013
    Location
    Arizona
    MS-Off Ver
    Excel 2007
    Posts
    71

    Re: Dividing cell is giving wrong answer

    It was set to automatic.

  8. #8
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: Dividing cell is giving wrong answer

    I'm clueless now. Maybe one of the Smart Guru's has an idea.

    Glad you solved it. Wish we knew that the problem was.
    Do you have vision problems like this often?

  9. #9
    Registered User
    Join Date
    08-14-2013
    Location
    Arizona
    MS-Off Ver
    Excel 2007
    Posts
    71

    Re: Dividing cell is giving wrong answer

    First time. It wasn't my computer, so I can safely say my files weren't affected!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] SUMPRODUCT giving me different answer
    By coach.32 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-09-2013, 06:05 AM
  2. [SOLVED] SUMIF not giving me the correct answer
    By Cathy Brausa in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-27-2012, 02:05 AM
  3. sum formula giving a cell reference in the answer
    By stanadon in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-09-2012, 06:29 AM
  4. Vlookup giving wrong answer
    By toclare84 in forum Excel General
    Replies: 5
    Last Post: 08-26-2010, 08:53 AM

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