Hello All,
I am attempting to run a simple calculation involving 3 columns:
- ColumnA
- ColumnB
- ColumnC
ColumnC is equal to: [ColumnB]/[ColumnA]
Both columns have a range of numbers from 0 up to approximately 800. In my database, there are records where zeros occur in both ColumnA and ColumnB. As well, there are records where ColumnB has a number greater than 0, but ColumnA is 0 (and vice versa) in the same record. In these cases, I end up with #Num! and #Div! errors. I need to keep the "zeros" as they are important important data.
Hope someone can help.
Cheers!