Forum Discussion
How to change my field selection.
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
4 Replies
If I understood the logic correctly, formula shall return 5 if at least on value in D3:V3 is greater than 300 AND less than 1000, when
=IF(OR( (D3:V3>300) * (D3:V3<1000)), 5, 0)If we use OR when condition for any cell and any value in it always returns true (any number is more than 300 OR less than 1000). Thus applied to the range we always have true.
- The formula =IF(OR(D3:V3>300, D3:V3<1000), 5, 0) seems to be working from Nikolino DE. Thank you
- Nikolino DE that worked. Thank you!!
