I know there is probably a simple answer to the below, but I can not get this to run correctly
DstNfin: IIf([DISTANCE]<([DSTFUR]+1.01 And [DISTANCE]>([DSTFUR]-1.01)),[RWNF],0)
What I want is if Distance is between Dstfur plus or minus 1.01 to return RWNF. If not it would reutrn 0. For example, DISTANCE is 8 and DSTFUR is 6, would return 0. If DISTANCE was 8 and DSTFUR is 7, would return RWNF.