Building a spreadsheet that has daily updates.....
I have it doing all the calculations i want - and even some great cell coloring via 'conditional formatting' - thanks to the help i've found on this site.
Since i have daily updates, i've copied the formulas from several columns down.... so needless to say, since there are no numbers to calculate, i have a spreadsheet full of "#DIV/0!"....
How do i 'hide' that error and have it magically disappear when i enter the numbers for the day?
I have it doing all the calculations i want - and even some great cell coloring via 'conditional formatting' - thanks to the help i've found on this site.
Since i have daily updates, i've copied the formulas from several columns down.... so needless to say, since there are no numbers to calculate, i have a spreadsheet full of "#DIV/0!"....
How do i 'hide' that error and have it magically disappear when i enter the numbers for the day?