Results 1 to 4 of 4

Handling error in formula with blank cell?

Threaded View

  1. 10-09-2008, 06:49 PM #1
    Chantel1326
    Chantel1326 is offline
    Registered User
    Join Date
    10-09-2008
    Location
    Hawaii
    Posts
    5

    Handling error in formula with blank cell?

    When I enter this formula I get a #VALUE! error. I think it's because cell AG46 has an IF formula that results in "blank" if 0. How do I fix this error so that it includes cell AG46 and if cell AG46 is blank it counts it as a zero?
    =SUM(A12)-(AG46*8) (=40 is the answer I'm looking for)
    =SUM(40)-(0*8)
    Last edited by Chantel1326; 10-09-2008 at 08:06 PM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Checking for blank cells before running macro
    By DavidSmithson in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-08-2008, 11:18 AM
  2. Exclude Blank cells when matching against other cells.
    By Neil07979 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-05-2008, 09:28 AM
  3. Ignoring blank cells in an IF statement formula
    By Macro-wave in forum Excel General
    Replies: 4
    Last Post: 08-26-2008, 10:20 AM
  4. If statement meant to return blank cells doesn't return blank cells?
    By BrakZak in forum Excel General
    Replies: 3
    Last Post: 11-22-2007, 07:53 AM
  5. leaving cell blank as a result of two blanks cells
    By Mister Big Shot in forum Excel General
    Replies: 3
    Last Post: 03-24-2007, 03:10 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1