Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Excel Error on IF statement
Message
De
30/07/2001 17:26:47
 
 
À
30/07/2001 16:23:05
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Divers
Thread ID:
00537452
Message ID:
00537500
Vues:
13
>I am attepting to use the following formula in an Excel PivotTable via automation and keep getting an error on this statement:
>
>=IF(hit_type='U',IF(dtot_unq=0,0,dus_unq / dtot_unq),IF(dtot_hits=0 ,0,dus_hits / dtot_hits))
>
>Not sure what the problem is (all the fields exist).

I think you need to do double quotes with strings in Excel. This is running on the Excel side right?
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform