I am looking to find a formula in excel by which I can calculate how many times 1st integer is greater than second.
For Example:
A = 5
B = 1
Ans: (A/B) i.e 5/1 = 5
A is 5 times bigger than B. Simple Enough!!
Problem occurs when one integer is negative, Example:
A = 10
B = -5
How do I calculate in excel, how much time A is bigger or smaller than B.
Condition: Any Integer could be negative (A or B)
Thank You!!
What I tried:
A = 10
B = -5
C = A / B
C = 10 / -5
C = -2 which is incorrect :(**
CodePudding user response:
Maybe try:
Formula in A4
:
=(MAX(A1:A2)-MIN(A1:A2))/MIN(ABS(A1:A2)) (OR(MIN(A1:A2)>0,MAX(A1:A2)<0))
CodePudding user response:
Thank You@ JvdV and Notus_panda: This works perfectly!!
=(MAX(B1:B2)-MIN(B1:B2))/MIN(ABS(B1:B2)) (OR(MIN(B1:B2)>0,MAX(B1:B2)<0))
="A is " & (MAX(B1:B2)-MIN(B1:B2))/MIN(ABS(B1:B2)) (OR(MIN(B1:B2)>0,MAX(B1:B2)<0)) & " times " & IF(B1<B2,"smaller","bigger") & " than B"