Forum Discussion
Solved
Blank Not equal to ""
In a formula for one cell it tests to see if value ="". If so it set a different cell to "". Now in a separate formula that is applying a mathematics formula based on several cell values. For the on...
- Could you change the original formula to show 0 and then just format it as a blank?
Alternatively wrap your reference to the cell containing "" in N( ) e.g, N( A2 ) will convert "" in A2 to 0
Could you change the original formula to show 0 and then just format it as a blank?
Alternatively wrap your reference to the cell containing "" in N( ) e.g, N( A2 ) will convert "" in A2 to 0
Alternatively wrap your reference to the cell containing "" in N( ) e.g, N( A2 ) will convert "" in A2 to 0
Thanks Wyn, the N() option worked great!!!
