Thread: Data format
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Monroe Monroe is offline
external usenet poster
 
Posts: 6
Default Data format

I have a spreadsheet that I am pulling figures from several different
worksheets. They are all added/subtracted together. Then once I have my
figures pulled together I balance. However, when I subtract two figures
sometime the difference reads 0 sometimes it reads -. Normally this would
bother me, but I have a If statement which says, if this cell is <0 then
"Balanced". So, what happens is when the - appears the spreadsheet says
balanced, when the 0 appears the cell does not say "Balanced". What would
make this happen?