Return blank cell using a formula
Here is my formula: =if(iserr(h3/g3),"",h3/g3)
The problem is I am using this data in a line chart and whenever there is a "", my line drops all the way down to zero. Can I make the formula completely blank the cell rather than filling it with a space? |
Try
=if(iserr(h3/g3),NA(),h3/g3) -- Regards, Peo Sjoblom "asach" wrote in message ... Here is my formula: =if(iserr(h3/g3),"",h3/g3) The problem is I am using this data in a line chart and whenever there is a "", my line drops all the way down to zero. Can I make the formula completely blank the cell rather than filling it with a space? |
See if this makes it look any better:
=IF(ISERR(H3/G3),NA(),H3/G3) Regards Trevor "asach" wrote in message ... Here is my formula: =if(iserr(h3/g3),"",h3/g3) The problem is I am using this data in a line chart and whenever there is a "", my line drops all the way down to zero. Can I make the formula completely blank the cell rather than filling it with a space? |
All times are GMT +1. The time now is 01:01 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com