Forum Discussion
Solved
HELP - conditional summing a field based on a product number and week number from another table
Hello I have attached 2x sheet screenshots below - one called 'target' which I want to put the formula in and one called ''source' which is where is want to pull the info from What is the r...
The formula in ABC!M2 is
=IF(OR(O2="Positive"),"0",IF(OR(O2="Negative"),"1"))
- "0" and "1" are text values, not numbers. You should use 0 and 1 instead.
- There is no need to use OR here
no problem, i have attached a sheet below
I have deleted data out of this leaving only the 2 sheets I want to look up from and the one I want to put info in
*link removed*
The formula in ABC!M2 is
=IF(OR(O2="Positive"),"0",IF(OR(O2="Negative"),"1"))
- "0" and "1" are text values, not numbers. You should use 0 and 1 instead.
- There is no need to use OR here