Thread: If Then Formula
View Single Post
  #1  
Old November 7th 06, 10:34 PM posted to microsoft.public.outlook.program_forms
Aggie G
external usenet poster
 
Posts: 1
Default If Then Formula

I am trying to create an If Then formula that will populate a name when a
spefic checkbox is selected. The checkboxes a

lobby
boardroom
training room

When one of these checkboxes is selected, I want the checkbox name to
appear. This is the formula that I created, but it is not working:
IIf( [lobby] =true, "Lobby" ) or IIf( [Training Room] =true, "Training Room"
) or IIf( [Boardroom] =true, "Boardroom" )

Instead of getting the word in () I am getting a value of -1 or 0. Please
help.


Ads