Hi a simple formula, I need to add across a row of cells,i use "example" =sum(a1:l1)-sum (n1:p1), ok so far but this formula has to cover a whole page and some rows will remain empty the current formula returns a 00.0 I would like it to leave the target cell empty.?<>?
Last edited by ned 51; 09-06-2013 at 10:36 AM.
Use Custom Format and format the target cell like this.
0;;
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
the problem is I don't know from any given time which rows will remain empty, and was hoping to add to the current formula so that it would return an empty target cell whenever this occurred.
Then format all your range with numbers in this way. If a 0 exist then the cell will looks like empty.
that's confused me where does that fit into the current formula?
In your example you can format like this range A1:P1.
But as you insist for a formula, here is one.
=IF(SUM(A1:L1)-SUM(N1:P1)=0,"",SUM(A1:L1)-SUM(N1:P1))
sorry to make you cross I am still new at this and understanding the double brackets and commas etc is taking its time, however I thank you for your help, the formula has been applied and functions just as I wanted it to.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks