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.![]()
Try this
=ABS(A2-A3)
Bookmarks