B Bottom Guest Oct 24, 2005 #1 As state above that whats wrong with the following formula? =iff([Product]=Home,1,0)
P P_Henry Registered User. Local time Today, 19:22 Joined Dec 3, 2003 Messages 63 Oct 24, 2005 #2 Should it be IIF([....])?
W WIS Registered User. Local time Tomorrow, 06:22 Joined Jan 22, 2005 Messages 170 Oct 24, 2005 #3 Bottom said: As state above that whats wrong with the following formula? =iff([Product]=Home,1,0) Click to expand... ... or perhaps: =IIF([Product]="Home",1,0) if the Product field is a Text(String) field.
Bottom said: As state above that whats wrong with the following formula? =iff([Product]=Home,1,0) Click to expand... ... or perhaps: =IIF([Product]="Home",1,0) if the Product field is a Text(String) field.
