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,
|