currently, this is my selection. =IF(OR(D3:V3<1000), 5, 0)

I want to search D3:V3 if the amount is greater than 300 or less than 1000. I still want to end with 5, 0.

How can I do this?

Thanks

​currently, this is my selection. =IF(OR(D3:V3<1000), 5, 0)I want to search D3:V3 if the amount is greater than 300 or less than 1000. I still want to end with 5, 0.How can I do this?Thanks  Read More

​