ExcelBanter - Formula Help

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Formula Help (https://www.excelbanter.com/excel-worksheet-functions/143352-formula-help.html)

Ed Davis

Formula Help

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

THANKS IN ADVANCE

Ed Davis

excelent

Formula Help

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

"Ed Davis" skrev:

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

THANKS IN ADVANCE

Ed Davis

Sebation.G[_2_]

Formula Help

try:
=(E19<0)*(G19=0)*(F190)*(C19*E19)

--
Regards,

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

THANKS IN ADVANCE

Ed Davis

All times are GMT +1. The time now is 10:05 AM.