View Single Post
  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

Sure, try

=IF(OR(C8={3,4,5}),25,0)


Regards,

Peo Sjoblom


"pbeattie" wrote in message
...
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,