the answer comes up being short. For example 2*2 should be 4 but it totals
it at 3.
the answer comes up being short. For example 2*2 should be 4 but it totals
it at 3.
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" <[email protected]> wrote in message
news:[email protected]...
> the answer comes up being short. For example 2*2 should be 4 but it
> totals
> it at 3.
>
Please post your exact formulas, input values and result.
--
Kind regards,
Niek Otten
"Dianna" <[email protected]> wrote in message
news:[email protected]...
> the answer comes up being short. For example 2*2 should be 4 but it
> totals
> it at 3.
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks