Formula

[Ed Davis]

I am looking to do the following but have not has 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]

Maybe you mean:
=IF(AND(E19<>0,G19=0,F19>0),C19*E19,1)

 

[T. Valko]

Well, it kind of depends on the requirements.

Are all 3 of these cells, E19:G19, supposed to contain numbers?

AND(G19=0)

If G19 is *empty* it will = 0. So, do you need to make sure it's a numeric
0?

This assumes those cells need to have some number entered in them:

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

Biff

 

[David Biddulph]

Or
=IF(AND(E19<>0,G19=0,F19>0),C19*E19,0)
as the OP asked for 0, rather than 1, for the exception case.

 

[Max]

=IF(AND(E19<>0,G19=0,F19>0),C19*E19,0)
as the OP asked for 0, rather than 1, for the exception case.

Thanks for correction, David.
It should be as you mentioned above.

---