Knockoutpie
Board Regular
- Joined
- Sep 10, 2018
- Messages
- 116
- Office Version
- 365
- Platform
- Windows
Hi All, I have a formula comparing two numbers, In most cases due to rounding it's above $0.00 or under $1.00. (ignore these)
In some cases the difference is greater than $1.00 or less than $-1.00
How can I get this formula to display that?
=(SUMIF(AG:AG,AG20,AD:AD)-I20)
Current value of this formula is 363.16, i would like this formula result to say "exceed"
In some cases the difference is greater than $1.00 or less than $-1.00
How can I get this formula to display that?
=(SUMIF(AG:AG,AG20,AD:AD)-I20)
Current value of this formula is 363.16, i would like this formula result to say "exceed"