Forum Discussion
Solved
Find Minimum Date in 5 Different dates
Hi All, Is there any way that we can create a formula using IF funtion to find out the minimum date in 5 Different dates & we cannot use any other funtion. Because i need to use this in different ar...
As variant
=IF( (B2<C2)*(B2<D2)*(B2<E2)*(B2<F2), B2, IF( (C2<B2)*(C2<D2)*(C2<E2)*(C2<F2), C2, IF( (D2<B2)*(D2<C2)*(D2<E2)*(D2<F2), D2, IF( (E2<B2)*(E2<C2)*(E2<D2)*(E2<F2), E2, F2 ))))
- i am aware that MIN() works in Excel but i am using a unique application where limited excel formulas will work.
So If the formula available with IF funtion will be helpful in this case.As variant
=IF( (B2<C2)*(B2<D2)*(B2<E2)*(B2<F2), B2, IF( (C2<B2)*(C2<D2)*(C2<E2)*(C2<F2), C2, IF( (D2<B2)*(D2<C2)*(D2<E2)*(D2<F2), D2, IF( (E2<B2)*(E2<C2)*(E2<D2)*(E2<F2), E2, F2 ))))- Yes, i got it
