Function not returning correctly please look

[AA76]

=IF($J7=0,IF($F7>0,"Lost",""))

I want the cell to be blank if neither one of the criteria is met. What do I do?

Thanks

[swatsp0p]

=IF($J7=0,IF($F7>0,"Lost",""))

try:

=IF(AND($J7<>0,$F7<=0),"","LOST")

Logic: when both j7<>0 and f7 is not greater than zero, blank is returned

HTH

[VBA Noob]

Hi,

Not sure what F7 = 0 is doing but you could try this

=IF(F7="","",IF(OR(F7=0,F7>1,),"Lost",""))

If F7 = 1 it returns blank

VBA Noob

[AA76]

The formula I have is

=IF($K7=0,IF($G7>0,"Lost",""))

What I am trying to find is if column K has a 0 or blank but column G has a number then I want the cell to say Lost.

The foluma works but in the ones that don't say lost it says False, I just want the false ones to be blank.

Thanks

[VBA Noob]

Does this work for you

=IF(OR(K7=0,K7=""),IF(G7>0,"Lost",""),"")

VBA Noob

[AA76]

Thanks that worked!