| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
showing blank cells
I have a spredsheet that uses formulas to calculate percentages. Info is
added throughout the month so some cells with formulas that have not yet been used show -100%. These false numbers naturally go to the graph page. How can I eliminate a calculation in unused cells where there is a formula that doesn't yet have numbers to work with? |
|
#2
|
|||
|
|||
|
Steve K wrote...
I have a spredsheet that uses formulas to calculate percentages. Info is added throughout the month so some cells with formulas that have not yet been used show -100%. These false numbers naturally go to the graph page. How can I eliminate a calculation in unused cells where there is a formula that doesn't yet have numbers to work with? Hi Steve K, One way, =If(your_formula=-100%,"", your_formula) Regards, Kevin |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Non Blank - Blank Cells???? | Excel Discussion (Misc queries) | |||
| In Exel 2000, stop the blank cells (with formulas) from printing. | Excel Discussion (Misc queries) | |||
| how to skip the blank cells | Excel Discussion (Misc queries) | |||
| copy blank cells | Excel Discussion (Misc queries) | |||
| copy blank cells | Excel Discussion (Misc queries) | |||
Linear Mode
