Results 1 to 8 of 8

Changing cell value produces "#DIV/0!" error message

Threaded View

Preceptor Changing cell value produces... 06-18-2013, 04:32 AM
XOR LX Re: Changing cell value... 06-18-2013, 04:46 AM
Preceptor Re: Changing cell value... 06-18-2013, 06:25 AM
Preceptor Re: Changing cell value... 06-18-2013, 09:03 AM
XOR LX Re: Changing cell value... 06-19-2013, 09:25 AM
Preceptor Re: Changing cell value... 06-20-2013, 04:56 AM
XOR LX Re: Changing cell value... 06-20-2013, 05:36 AM
Preceptor Re: Changing cell value... 06-20-2013, 08:15 PM
  1. #1
    Registered User
    Join Date
    06-04-2013
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    9

    Question Changing cell value produces "#DIV/0!" error message

    Can't work out why this error appears in a number of columns in my [refer attachment] spreadsheet.

    I am trying to have flexibility in Cell S23. However, whenever I type-in a value that is "not" 2.00% or 1.5%, this error occurs.

    Have tried two different formulas to test if either would make a difference: refers Cells J80 and J81 respectively. Neither works!


    A solution would be most welcome.
    Preceptor

Thread Information

Users Browsing this Thread

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

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