![]() |
when i input (=r3*s3) the answer is not correct?
the answer comes up being short. For example 2*2 should be 4 but it totals
it at 3. |
when i input (=r3*s3) the answer is not correct?
Hi
I can get that if I format the cells to Number, with no decimal places, and have 1.61 in R3 and 1.91 in S3. Check the format of the cells and what the formula bar actually says is in there. Also check Tools/Options/Calculation tab is set to Automatic. Andy. "Dianna" wrote in message ... the answer comes up being short. For example 2*2 should be 4 but it totals it at 3. |
when i input (=r3*s3) the answer is not correct?
Please post your exact formulas, input values and result.
-- Kind regards, Niek Otten "Dianna" wrote in message ... the answer comes up being short. For example 2*2 should be 4 but it totals it at 3. |
All times are GMT +1. The time now is 08:40 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com