IF problem

[dgavin]

can you help create this formula.

If D20 is less than or greater than E20 by 0.2 then 1 if not then 0

Thanks

 

[Jonmo1]

Try

=ABS(D20-E20)>0.2

 

[dgavin]

Slight amendment, can you help?


If D20 is between E20 and E20 + 0.5 or between E20 and E20 - 0.5 then 1, if not 0

 

[Jonmo1]

Then

=ABS(D20-E20)>0.5

 

[StillLearningExcel]

I've used .51 so it inclues 0.5 but you change it if you need to

=IF(AND(D20-E20>-0.51,D20-E20<0.51),1,0)

<TABLE style="WIDTH: 48pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=64 border=0 x:str><COLGROUP><COL style="WIDTH: 48pt" width=64><TBODY><TR style="HEIGHT: 13.2pt" height=18><TD id=td_post_2625981 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 48pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 13.2pt; BACKGROUND-COLOR: transparent" align=right width=64 height=18 x:num></TD></TR></TBODY></TABLE>