Oct 12 2022 02:14 AM
Hi,
I want to create a formula that gives the number 2 if two cells are equal, but if the numbers are different - I want to get the difference between them, but in negative form (For example: If A1 is 6 and B1 is 4, I want to get -2). I want to clarify that a simple sum formula probably isn't good in that case because in some cases A would be the bigger number, and in other cases B would be the bigger, and I want it to always be negative.
I made the first step of the formula - =IF(A1=B1,2) - but don't know how to proceed from here.
Thanks in advance!
Oct 12 2022 02:31 AM
SolutionOct 12 2022 02:45 AM
Oct 12 2022 03:21 AM
Oct 12 2022 05:20 AM
Oct 12 2022 02:31 AM
Solution