Forum Discussion
Formula help
I need to assistance on a formula. I have most of it but the last part I am not sure what to do. 1) If cell G4 > L3 show value of cell F4 2) If cell G4 <= M3 show 0 3) If cell I4 has a value...
You conditions have a few 'holes'. For example, what if G4<=L3 but the neither of the other conditions apply?
Maybe you really want IF G4>L3 AND G4>M3 AND I4 has a value THEN show F4?
=IF(AND(G4>L3,G4>M3,NOT(ISBLANK(I4)),F4,"")
otherwise, maybe you could clarify more on your logic.
Maybe you really want IF G4>L3 AND G4>M3 AND I4 has a value THEN show F4?
=IF(AND(G4>L3,G4>M3,NOT(ISBLANK(I4)),F4,"")
otherwise, maybe you could clarify more on your logic.