View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Clarence Crow Clarence Crow is offline
external usenet poster
 
Posts: 6
Default formula for +- comparison check Excel 2003

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