Formula
 

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(F190)
THEN C19*E19
ELSE 0

THANKS IN ADVANCE

Ed Davis

Formula
 

Maybe you mean:
=IF(AND(E19<0,G19=0,F190),C19*E19,1)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Ed Davis" wrote:
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(F190)
THEN C19*E19
ELSE 0

THANKS IN ADVANCE

Ed Davis

Formula
 

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,F190,G19=0), C19*E19,0))

Biff

"Ed Davis" wrote in message
...
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(F190)
THEN C19*E19
ELSE 0

THANKS IN ADVANCE

Ed Davis

Formula
 

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

"Max" wrote in message
...
Maybe you mean:
=IF(AND(E19<0,G19=0,F190),C19*E19,1)

"Ed Davis" wrote:
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(F190)
THEN C19*E19
ELSE 0

THANKS IN ADVANCE

Ed Davis

Formula
 

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
=IF(AND(E19<0,G19=0,F190),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.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---