View Single Post
  #1   Report Post  
pbeattie
 
Posts: n/a
Default How do I use a range of numbers in an if statement?

I would like to use a range of numbers in an IF statement. As an example
IF("C8 =3,4,or5",25,0) which is meant to read if cell C8 is equal to the
number 3, the number 4, or the number 5, then show 25, if not show 0. Is
there a simple way to write this range of numbers into this IF statement?

Thanks,