Formula help

%3CLINGO-SUB%20id%3D%22lingo-sub-2548579%22%20slang%3D%22en-US%22%3EFormula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2548579%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20to%20assistance%20on%20a%20formula.%20I%20have%20most%20of%20it%20but%20the%20last%20part%20I%20am%20not%20sure%20what%20to%20do.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1)%26nbsp%3B%20If%20cell%20G4%20%26gt%3B%20L3%20show%20value%20of%20cell%20F4%3C%2FP%3E%3CP%3E2)%26nbsp%3B%20If%20cell%20G4%20%26lt%3B%3D%20M3%20show%200%3C%2FP%3E%3CP%3E3)%26nbsp%3B%20If%20cell%20I4%20has%20a%20value%20show%200%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBelow%20is%20all%20I%20have%20been%20able%20to%20figure%20out%20so%20far%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIF(AND(%24G4%26gt%3BL%243%2C%24G4%26lt%3B%3DM%243)%2C%24F4%2C%22%22)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2548579%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

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.