major stressor

[Guest]

I've tried the below formula and am not getting the result
I need, can you help? What I need is the if the answer is
20% or 200,000, whichever is less.

=IF(OR((K27-J27)>20%*J18,K27-J27>200000),(K27-J27),0)

 

[Frank Kabel]

Hi
try
=IF((K27-J27)>MIN(0.2*J18,200000),K27-J27,0)

 

[Guest]

Thanks Frank, you pull through for me once again!

-----Original Message-----
Hi
try
=IF((K27-J27)>MIN(0.2*J18,200000),K27-J27,0)




--
Regards
Frank Kabel
Frankfurt, Germany



.