Forum Discussion

ljsbloomy's avatar
ljsbloomy
Copper Contributor
Jul 14, 2021

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

 

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

 

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

excel

1 Reply

  • mtarler's avatar
    mtarler
    Silver Contributor
    Jul 14, 2021
    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.

Resources