I want to enter a number in A1, then enter another number in A2 and show the difference in A3.
Using this formula (=MAX(A1)-A2) works great until the number I enter in A2 is higher than in A1. Then I get a negative number.
How can I get a positive answer to show in A3 regardless of whether or not the number in A2 is higher or lower than in A1?
Positive differences.xlsx
Thank you
Last edited by tom hatten; 03-12-2015 at 03:50 PM.
Use the ABS() absolute value function: =ABS(number1-number2)
Originally Posted by shg
Thank you MrShorty, exactly what I wanted.
I'm really sorry but I've jumped the gun a bit and thought I could solve the second half of my problem but it's throwing up errors.
Following on from my first post:
If A2 is the same as A1 then I want A4 to equal 10
If A2 is within 3 of A1 then I want A4 to equal 5
If A2 is within 5 of A1 then I want A4 to equal 3
If A2 is greater then 5, I want A4 to equal 0
Thank you
I guess I did not see your additional question last week.
If I understand what you are trying to do, I would probably do this using a lookup table and lookup function (see VLOOKUP() function, for example: https://support.office.com/en-us/art...8-93a18ad188a1 ) A lookup table likeand a lookup function like =VLOOKUP(A3,$D$2:$E$5,2,true) (where A4 has your ABS(...) function and D2:E5 contains the lookup table).
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks