L

#### Legacy 36500

##### Guest

Let me paste a formula evaluation to show what's wrong.

=IF(FS1961+HY8>=HY2,IF(FS1961+HY8<=HY3,FS1961+HY8,0),0)

=IF(

__>=HY2,IF(FS1961+HY8<=HY3,FS1961+HY8,0),0)__

*2.2689*+*0.0001*=IF(

**>=2.2667,IF(FS1961+HY8<=HY3,FS1961+HY8,0),0)**

*2.26900000000001*=IF(

**>=2.2667,IF(**

*2.26900000000001***<=2.269,**

*2.26900000000001***,0),0)**

*2.26900000000001*So, to translate the math and logistics quickly:

=IF(FS1961+HY8>=HY2,IF(FS1961+HY8<=HY3,FS1961+HY8,0),0)

=IF(

**>=2.2667 {True},IF(**

*2.26900000000001***<=2.269{FALSE},**

*2.26900000000001***,0),0)**

*2.26900000000001*How do I stop excel from inserting .00000000000001 on a this simple math equation?

Before you tell me to correct it in the cell, the cells are referencing, meaning the variables, and therefore the condition, won't always be present in that particular location (it's all dynamic), and there are a LOT of these checks.

I also had checked prior cells and it appears right on this location, when the # rolls over and truncates the 0's.

Formatting the cells as numbers didn't help.