SUMIF and text with decimals
Thanks Franz
"Franz Verga" wrote:
Nel ,
Mark ha scritto:
Why does Excels SUMIF formula consider cells with text data such as:
2.1 and 2.10 as equal (it sums their values) when used in the range
and criteria?
Hi Mark,
because Excel treat as number text that can be treated as number, when you
use it in calculation.
So if you use a number formatted as text in a calculation, it will be
treated as a number.
--
(I'm not sure of names of menus, options and commands, because
translating from the Italian version of Excel...)
Hope I helped you.
Thanks in advance for your feedback.
Ciao
Franz Verga from Italy
|