If A is true, then do B

[boatman37210]

=IIf([Text34]<=2644,0,IIf([Text34]<=7164,650,IIf([Text34]>=242506,22000,[Text34]*0.0907194)))

The above formula works as is in the field I have it in, but need it performed only if [Label5] is marked yes. I guess what I need is what goes in front of the above formula. I've looked through the forum, but it is so huge I had no luck finding what I needed.

If [Label5] is no, I need it to go to [Label6] and if [Label6] is yes, perform another calc like the one above. If [Lable6] is no, I need an error message.

Hope this is clear. Any help is greatly appreciated.

Thanks.

 

[EdFred]

vba code can be your friend.

 

[EdFred]

If Me.Label5 = -1 Then
If Me.Text34<=2644 Then
Me.Text34 = 0
etc...

 

[gemma-the-husky]

the syntax may be

if label5.caption="yes" then etc