Formula Help

[Ed Davis]

I am looking to do the following but have not had any luck using the and
function Can anyone help?
This is what I want to do.

=IF(E19<>0)
AND(G19=0)
AND(F19>0)
THEN C19*E19
ELSE 0

THANKS IN ADVANCE

Ed Davis

 

[Guest]

=IF(AND(E19<>0,F19>0,G19=0),C19*E19,0)


"Ed Davis" skrev:

 

[Sebation.G]

try:
=(E19<>0)*(G19=0)*(F19>0)*(C19*E19)