I am Subracting two Double Variable numbers getting 0 as output But for Some other values I am getting output as like this -2.98023E-08 why it is happening

[Gopi_Krishna1 (Gopi Krishna)]

[ppr (Peter)]

internally computers will get a small fraction as a result.

have a look here and also for some solution approaches:

I have two values First one is 263926176.9 and Second One is 263926176.9 Both are same I am trying to subracting this Expecting output as 0 But I am getting this Value -2.98023E-08

Suggest a Correct way to get 0 in Output, Working in Excel

[Gopi_Krishna1 (Gopi Krishna)]

But if i minus this two Values by manual means i am getting Zero as output

[ppr (Peter)]

@Gopi_Krishna1

i minus this two Values by manual

what exactly is meant by manually?
Did you checked the referenced topic in detail?

[Gopi_Krishna1 (Gopi Krishna)]

i entered =G178-I178 formula in seperate cell i am getting 0 as output, see for all the remaining rows i am getting 0 as output