Have been using
<IF(logical_test, [value_if_true], "")>
to return a blank cell. Problem is that if the cell is blank and used in a subsequent calculation #VALUE! is returned. How do I get a blank cell that behaves as if it were a 0 but doesnt show a 0?
what is the subsequent formula? perhaps that can be set to ignore ""...or maybe you will need to have the 1st formula return 0?
maybe a bit more info will help us to help you?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Here is the formula
Which either puts a number of "" into the cell, say "A1"
Please Login or Register to view this content.
Put=A1+1. into cell "B2"
You will get either a number or #VALUE! depending what was in "A1"
ok then try =SUM(A1,1)
Also, I see a bit of a conflict in your formula....
=IF(ISBLANK(B8),"",IF(OR(P8="",COUNT(C8:D8)=0),IF(COUNT(C8:D8)=2,25,""),P8))
In your OR, you test for COUNT(C8:D8) = 0, and if it is, then you test for COUNT(C8:D8)=2...if it tests TRUE for 0, it can never test TRUE for =2, so you will never get 25?
Could you have the If function return 0 instead of ""? If you go into the main Excel options dialog, one option is whether or not to display 0 values. If this is correctly selected all 0 values will not be displayed, without further need for additional IF functions or other.
Another possibility would be to use number formatting. There are 4 sections to a number format, if you leave the 0 section empty, 0 values will not be displayed.
Instructions here: http://www.extendoffice.com/document...ide-zeros.html
Originally Posted by shg
Thanks MrShorty.
Your reply gives a simple fix for my problem. Just have to change a few "" for 0 in my formulas.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks