| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
