| 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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula for +- comparison check Excel 2003
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" wrote: 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula for +- comparison check Excel 2003
Thanks!
It was the ABS function that was missing from my head! On Tue, 7 Nov 2006 16:51:02 -0800, Ron Coderre wrote: 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" wrote: 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 -Please reply to group as my email addr is fake! -Regards CC |
| Reply |
| 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 | |||
Linear Mode
