Which one takes precedence? What do you want if K3 is <=1 AND E3 is blank?
Do you want J3 to display H3 or blank?

"belvy123" wrote:

Hi All

I have a sheet where I want to be able to check 2 conditions tyo achieve the
proper result
-- here is my example


if K3 <=1 then display the value of H3 in cell J3 and if E3 is = to a blank
cell then I want to display a blank cell in J3

I am sure this is simple but I cant figure it out
Thanks
Dan N
crunchnin numbers