May 17 2018
11:16 PM
- last edited on
Jul 31 2018
08:10 AM
by
TechCommunityAP
May 17 2018
11:16 PM
- last edited on
Jul 31 2018
08:10 AM
by
TechCommunityAP
Always when i sum two large no. using the formula [=SUM(:)] it gives '0' as output.
Please help me out !
May 17 2018 11:25 PM
Hi,
Let me now length of values.
Use anyone of folloiwng, if you sum only two large numbers.
=6778978987+676768767
=A2+79789489161
=A2+B2
=SUM(A2:B2)
=SUM(A2,B2)
=SUM(6789461654,874615467)
=SUM(9879874615,B2)
Dont use. For (eg.)
=sum(67978978:46546987)
May 17 2018 11:46 PM
I've tried that one too, but still the output comes zero
But heartly thanks for your response
May 18 2018 04:04 AM
Maybe your numbers are text.
Check it by using ISNUMBER(A1).
May 18 2018 04:31 AM