|There is difference between 0 and Blank, so you need to be careful. The reason why C6 is blank can make a difference in what your formula returns.|
For example, this formula will return a blank cell for 3 conditions of C6:
1 - C6 contains a 0 (e.g. You entered 0 in the cell)
2 - C6 contains a formula that evaluates to 0 (e.g. =A1-A1)
3 - C6 is physically empty (e.g. You selected C6 and hit the Delete key)
However, if C6 is blank due to a formula that returns a blank cell, then the cell will be blank, but it won't equal to 0.
e.g. If C6 contains this formula and A1 = 4, then C6 will be blank:
However, the Nested IF formula above will not consider C6 to be equal to 0 and therefore won't return a blank cell.
If you really want to check for both 0 and a blank C6 that is blank for any reason, then try this:
In this case, you are actually checking for 0 or "". If either one of those is true, the Nested IF will return a blank cell.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.