hi, i have a IF formula.
=IF(AND($C175="product A",AND($F175>=39448,$F175<=39532)),$J175,0)
were i have highlighted in red, rather than it looking directly at the cell reference in question as it is now. i'd like it to look at 2 cells: i.e. cell A would have the letter C in it and cell B2 going downwards would have the range 175 to 185 going down the column.
now, i thought something like: $B1,B2= would work, but i cant get it too.
can any1 give me support please?
=IF(AND($C175="product A",AND($F175>=39448,$F175<=39532)),$J175,0)
were i have highlighted in red, rather than it looking directly at the cell reference in question as it is now. i'd like it to look at 2 cells: i.e. cell A would have the letter C in it and cell B2 going downwards would have the range 175 to 185 going down the column.
now, i thought something like: $B1,B2= would work, but i cant get it too.
can any1 give me support please?