Thread: Formula Help
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
excelent excelent is offline
external usenet poster
 
Posts: 695
Default 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