Formula needs something--#REF!??

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))
 
F

Frank Kabel

Hi
try:
=IF(AND(K16>J16,K27+L31>J27,K27+L31<=I122),MAX(MIN(K27+L31-J27,K16-K27+
L31),0),"")
 
G

Guest

Thanks Frank.
-----Original Message-----
Hi
try:
=IF(AND(K16>J16,K27+L31>J27,K27+L31<=I122),MAX(MIN (K27+L31-J27,K16-K27+
L31),0),"")


--
Regards
Frank Kabel
Frankfurt, Germany



.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top