Hello. I hope there is someone out there that can help. I need to do the following in Excel 2010. Subtract X from Y IF X<Y. Y-X if X<Y to state again. How can I do this in one cell? I am new to Excel and appreciate help in this forum. Thanks again.
New Excel User
- Thread starter msdeb314
- Start date
- Joined
- Mar 21, 2011
- Messages
- 1,960
- Reaction score
- 0
- Points
- 36
- Excel Version(s)
- O365
Try this
=ABS(A2-A3)
=ABS(A2-A3)