Sharepoint Forum

 
Home » Forum » Sharepoint       Ask a questionRSS Feeds

Conditional Logic in Infopath formula controls

  Asked By: Wendy Warren         Date: Mar 18, 2010      Category: Sharepoint      Views: 1009
 

Can anyone tell me how I can put the following formula into an
infopath field? It's the only one I can't figure out because I can't
get the THEN bit to provide any options other than text formatting

=IF(Score<15,"Minor",IF(Score<25,"Significant",IF
(Score<35,"Major","Huge")))

In the SPv2 list this formula returned one of three values based on
the number referenced in the column called Score. Infopath doesn't
like the formula and I can't figure out how to get the THEN bit of the
statement in. Adding a condition when column X contains or is equal to
Z only gives me the option to THEN format the text colour and style

Can someone help?


Do you know someone who can help? Share a link to this thread on twitter, or facebook.

Tagged:            

 

No Answers Found. Be the First, To Post Answer.

 
Didn't find what you were looking for? Find more on Conditional Logic in Infopath formula controls Or get search suggestion and latest updates.


Your Answer
  • Answer should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].