Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Excel 2000 VBA Application on Excel 2003 | Excel Worksheet Functions | |||
sum formula not working, producing incorrect answers Excel 2003 | Excel Discussion (Misc queries) | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
edit formula bar in excel 2003? | New Users to Excel |