Go Back   TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



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

MS Office Support


Reply
 
Thread Tools Search this Thread
  #1  
Old 17-02-2012
Member
 
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.

Reply With Quote
  #2  
Old 17-02-2012
Member
 
Join Date: Jul 2011
Posts: 618
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);" ").
Reply With Quote
  #3  
Old 17-02-2012
Member
 
Join Date: Jul 2011
Posts: 631
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.
Reply With Quote
Reply

  TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Tags: , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "How to set to leave blank value when there is no Data from Formula"
Thread Thread Starter Forum Replies Last Post
How to normalize a data formula in Microsoft Excel Purujeet MS Office Support 2 16-02-2012 08:01 PM
How to ignore blank cell in a range while using Data Validation Nicoloid MS Office Support 2 16-02-2012 07:13 PM
Formula for tracking annual leave in Microsoft Excel Kungfu Pandey MS Office Support 1 14-01-2012 05:29 PM
successful burn, but no data, still blank disc rohith Hardware Peripherals 18 11-06-2011 01:50 PM
How to define formula to Remove characters from text and leave numbers Recko Software Development 2 09-06-2009 12:45 PM


All times are GMT +5.5. The time now is 03:28 PM.