G
Guest
The below formula won't work for me, what I'm trying to
achieve is if K16 > J16 AND K27+L31 > J27, AND K27+L31 <=
I122, result if true cannot be more than K16-K27+L31, but
can be <=, if over, 0. Can someone help me?
=IF(AND(K16>J16,K27+L31>J27,K27+L31<=I122),K27+L31-J27(MAX=
(K16-K27+L31),0))
achieve is if K16 > J16 AND K27+L31 > J27, AND K27+L31 <=
I122, result if true cannot be more than K16-K27+L31, but
can be <=, if over, 0. Can someone help me?
=IF(AND(K16>J16,K27+L31>J27,K27+L31<=I122),K27+L31-J27(MAX=
(K16-K27+L31),0))