Robert Wyatt
Board Regular
- Joined
- Jul 15, 2012
- Messages
- 108
- Office Version
- 2019
- Platform
- Windows
I'm trying to fix up a sheet with Allowed annual figures and Estimated Annual figures. but if there is only one figure I would like to show 0 for the difference. the formula I have I can't seem to get right can you help?
Book1 | ||||
---|---|---|---|---|
A | B | |||
4 | Social Security Information | Amount | ||
5 | Allowed Monthly Gross | $ 1,770.00 | ||
6 | Estimated Monthly Gross | $ 1,596.96 | ||
7 | Difference | $ 173.00 | ||
8 | Allowed Annually Gross | $ 21,240.00 | ||
9 | Estimated Annually Gross | $ 20,760.48 | ||
10 | Difference | $ 480.00 | ||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
B7,B10 | B7 | =ROUND(IF(B6>B5,0,B5-B6),+ROUND(IF(B6<B5,0,B5-B6),2)) |