formula for +- comparison check Excel 2003

[Clarence Crow]

Hello...

I have a worksheet that calculates a fortnightly payment which
includes an amount subject to foreign exchange, which I get from
xe.com.

I receive this payment via EFT from an agency that bases it on it's
own forex value.

The resulting total payment could be over + or under - my calculated
payment.

What I need is a formula to compare the 2 payments and report if the
deviation is +- $0.50c, using an IF function.

It's possibly so simple, I can't see it.
Anyone help? TIA

-Please reply to group as my email addr is fake!

-Regards CC

 

[Guest]

See if these give you any ideas:

For
A1: (a numeric value)
B1: (a numeric value)

These determine if the absolute value of the differences is > 0.50
C1: =(MAX(A1:B1)-MIN(A1:B1))>0.50
or
C1: =ABS(A1-B1)>0.50

Does that help?
***********
Regards,
Ron

XL2002, WinXP

 

[Clarence Crow]

Thanks!
It was the ABS function that was missing from my head!

See if these give you any ideas:

For
A1: (a numeric value)
B1: (a numeric value)

These determine if the absolute value of the differences is > 0.50
C1: =(MAX(A1:B1)-MIN(A1:B1))>0.50
or
C1: =ABS(A1-B1)>0.50

Does that help?
***********
Regards,
Ron

XL2002, WinXP

-Please reply to group as my email addr is fake!

-Regards CC