Hello,
Could anyone help to combine the following two formulas? Thank you.
AND![]()
=IF(AND(N4<=J4,M4>=J4,F69="Odd"),1,IF(AND(N4>J4,M4>J4,N4<=I4,F69="Odd"),3,IF(AND(L4<K4,L4<B4,F69="Odd"),5,IF(AND(M4<J4,M4>B4,F69="Odd"),7,IF(AND(N4>=I4,M4>I4,F69="Odd"),9)))))
![]()
=IF(AND(L4>=J4,M4<=J4,F69="Even"),2,IF(AND(L4<J4,M4<J4,L4>K4,F69="Even"),4,IF(AND(N4>I4,N4>B4,F69="Even"),6,IF(AND(M4>J4,M4<B4,F69="Even"),8,IF(AND(L4<K4,M4<K4,F69="Even"),10)))))
Bookmarks