mtagliaferri
Registered User.
- Local time
- Today, 05:07
- Joined
- Jul 16, 2006
- Messages
- 550
I have an old expression which works fine:
I am now in a situation that I have to add a new [DutyType] so now I have also H to add as of a duty Type, therefore if Duty Type is O or H has to return 0, anything up to 6 return 6 otherwise returns BobNewNear.
Where do I add the H condition?
Code:
=IIf([DutyType]='O' Or [BobNewNear]=0,0,IIf([BobNewNear]<6,6,[BobNewNear]))
I am now in a situation that I have to add a new [DutyType] so now I have also H to add as of a duty Type, therefore if Duty Type is O or H has to return 0, anything up to 6 return 6 otherwise returns BobNewNear.
Where do I add the H condition?