Formula help

Copper Contributor

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 show 0

 

Below is all I have been able to figure out so far

 

IF(AND($G4>L$3,$G4<=M$3),$F4,"")

1 Reply
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.