jisen77895
New Member
- Joined
- Dec 8, 2005
- Messages
- 19
In cellB1 I have a formula as follows:
IF(CS154<>0,1-(CR154/CS154),"")
B1 is linked to a graph. If CR154 = 0 I really want B1 to be null, not contain something that will appear on the graph as 0.
B1 is formatted as 0.0%.
If B2 is truly null, I can't write
IF(CS154<>0,1-(CR154/CS154),b2) because the result shows 0.0%.
How can I write a formula so that the false portion of the IF statement makes the cell null?
IF(CS154<>0,1-(CR154/CS154),"")
B1 is linked to a graph. If CR154 = 0 I really want B1 to be null, not contain something that will appear on the graph as 0.
B1 is formatted as 0.0%.
If B2 is truly null, I can't write
IF(CS154<>0,1-(CR154/CS154),b2) because the result shows 0.0%.
How can I write a formula so that the false portion of the IF statement makes the cell null?