Microsoft works spreadsheet

  • Thread starter Thread starter jago5446
  • Start date Start date
J

jago5446

Hi i have been trying to do a spreadsheet and when i try to multiply 2 cells
it is giving me the incorrect answer 32*2.61 eg =c3*b3 the answer is 83.52
and it gives me 83.58 does anyone know what ive done wrong thankyou paul
 
jago5446 said:
Hi i have been trying to do a spreadsheet and when i try to multiply 2
cells
it is giving me the incorrect answer 32*2.61 eg =c3*b3 the answer is
83.52 and it gives me 83.58 does anyone know what ive done wrong thankyou
paul
Click to expand...

Post your question in the Works newsgroup and make sure to include the
version of Works you are using.

microsoft.public.works.win

Malke
 
It rounds up to two (2) decimals - try resetting to more decimals but in
currency mode will default to two decimals. Just try to divide 83.52 and
83.58 by 32 on a pocket calc and you will get same = 2.61.
Michael
 
jago5446 said:
Hi i have been trying to do a spreadsheet and when i try to multiply 2 cells
it is giving me the incorrect answer 32*2.61 eg =c3*b3 the answer is 83.52
and it gives me 83.58 does anyone know what ive done wrong thankyou paul
Click to expand...

ms.public.works.win
 
Back
Top