G
Guest
hi,
I have four five each contain number 5, 2, 3, 4, 6 in cell A1 to E1.
Now in a new cell let's say B1 i need to select the minum positive value
from below formula
formula 1 A1-B1 = 3
formula 1 A1-C1 = 2
formula 1 A1-D1 = 1
formula 1 A1-E1 = -1
How do i develop a formula to be able to show the value of (A1-D1) which is
the minimum positive value.
I have four five each contain number 5, 2, 3, 4, 6 in cell A1 to E1.
Now in a new cell let's say B1 i need to select the minum positive value
from below formula
formula 1 A1-B1 = 3
formula 1 A1-C1 = 2
formula 1 A1-D1 = 1
formula 1 A1-E1 = -1
How do i develop a formula to be able to show the value of (A1-D1) which is
the minimum positive value.