Hi how to combine these 2 formulas
IF A1>B2=A1-B1 IF B1>A1=B1-A1
thanks you
Hi how to combine these 2 formulas
IF A1>B2=A1-B1 IF B1>A1=B1-A1
thanks you
=if(A1>B2,A1-B1,B1-A1)
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Thank you alansidman
Another solution:
You wrote: IF A1>B2=A1-B1 IF B1>A1=B1-A1
But do you mean: IF A1>B1=A1-B1 IF B1>A1=B1-A1?
You can combine these formula: Please try: =ABS(A1-B1)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks