Validate Cell contents in formlua

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to find a clean way to code a formula to compare the content of a
cell to a long list of know values, and if it matches (TRUE) do one thing, if
not (FALSE) do another. Example:

IF(OR(Workup!$F2="hr",Workup!$F2="h1r",Workup!$F2="h2r",Workup!$F2="h3r",Workup!$F2="ur",Workup!$F2="fr",Workup!$F2="f1r",Workup!$F2="f2r",Workup!$F2="f3r",Workup!$F2="sar",Workup!$F2="ef"),(Workup!$I2*$D16)*2,0)

I would just like to say somthing like:
IF(Workup!$f2 = List of valid things, do true, do false)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top