Results 1 to 3 of 3

Thread: How to set to leave blank value when there is no Data from Formula

  1. #1
    Join Date
    Oct 2011
    Posts
    113

    How to set to leave blank value when there is no Data from Formula

    I have two columns of dollar amounts I want to add, E & F,and subtract the third, G, and the results in column H. So I entered the formula =Sum(E2+F2-G2) down column H and that works but it automatically enters $0.00 down the column. So I entered the following formula down column H and that got rid of the $0.00 unless there is a value in E, F or G but if the results just happens to total $0.00 then column H remains blank, I don't want that. =IF(E2+F2-G2<>0,(E2+F2-G2),""). How can I tweak this formula to leave column H only blank when there isn't anything entered.

  2. #2
    Join Date
    Jul 2011
    Posts
    627

    Re: How to set to leave blank value when there is no Data from Formula

    Assuming the case is that sometimes you have E,F, and G with no data, this formula should help: =IF(COUNTA(E2:G2)>0;(E2+F2-G2);" ").

  3. #3
    Join Date
    Jul 2011
    Posts
    638

    Re: How to set to leave blank value when there is no Data from Formula

    If tried to enter the formula in column H and I get an error message that it contains a typo, won't except it. So I tried =IF(COUNT(E2:G2)>0,E2+F2-G2,""). Try using commas instead of the semicolons: =IF(COUNTA(E2:G2)>0,E2+F2-G2,"") I removed the ()'s from the E2+F2-G2 portion and I removed the space from the final string.

Similar Threads

  1. How to normalize a data formula in Microsoft Excel
    By Purujeet in forum MS Office Support
    Replies: 2
    Last Post: 16-02-2012, 07:01 PM
  2. Replies: 2
    Last Post: 16-02-2012, 06:13 PM
  3. Formula for tracking annual leave in Microsoft Excel
    By Kungfu Pandey in forum MS Office Support
    Replies: 1
    Last Post: 14-01-2012, 04:29 PM
  4. successful burn, but no data, still blank disc
    By rohith in forum Hardware Peripherals
    Replies: 18
    Last Post: 11-06-2011, 12:50 PM
  5. Replies: 2
    Last Post: 09-06-2009, 11:45 AM

Posting Permissions

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