|Posted: October 20, 2007, 3:42 pm - IP Logged|
Is there a way to inpliment a formula where it would recognize a zero value and assign its numeric value to it?
Heres an example of what I am trying to find...
For the number 9 we have ZERO in the first column and ZERO in the second column... is there a way that in another area of the spreadsheet, that I can have it recognize this zero in the NINE spot and therefore record it as such. So when I inpliment past data, it would recognize that there were no 9's called in the first column and tells me 9's -- zero in first column and so on for other numbers?
I know it sounds confusing but i am hoping someone can help answer this.
We are all Lucky... just some of us don't realize it!