HeatherBrian
New Member
- Joined
- Oct 26, 2004
- Messages
- 23
I am trying to create an IIF statement that takes multiple items into account. I am able to write each if statement separately but an not sure how to combine them. I want both IIF statements to be under the expression actor. I need the following information to be returned. If Test1S is No than Factor is null; however, if Test1S is yes and Worksheet-General Information is yes than 75 otherwise 100. The purpose of this is to score different sections of an exam. If they do not need to complete Test1S than they should not receive any credit; however, if they have to complete they will either receive 100 (if no mistakes) or 75 (if mistakes).
Any help would be greatly appreciated.
Thanks.
Factor: IIf([Worksheet-General Information]=Yes And [Test1S]=Yes,75,100)
Factor1: IIf([Test1S]=No,Null)
Any help would be greatly appreciated.
Thanks.
Factor: IIf([Worksheet-General Information]=Yes And [Test1S]=Yes,75,100)
Factor1: IIf([Test1S]=No,Null)