Multiple IIf statements

T

terriblyconfused

I want to the following
If [field name1] = "text1" or "text2" then [field name2]/6*3 if not [field
name3]
Desparate for help, please.
Thanks
 
O

Ofer Cohen

Try

IIf ([field name1] = "text1" or [field name1] = "text2" ,[field name2]/6*3 ,
[field
name3])
 
T

terriblyconfused

That's brilliant thanks, think I was trying to be too complicated.
Thanks again


Ofer Cohen said:
Try

IIf ([field name1] = "text1" or [field name1] = "text2" ,[field name2]/6*3 ,
[field
name3])


--
Good Luck
BS"D


terriblyconfused said:
I want to the following
If [field name1] = "text1" or "text2" then [field name2]/6*3 if not [field
name3]
Desparate for help, please.
Thanks
Click to expand...
Click to expand...
 
Top