Forum Discussion
If(And) Function not returning expected value
I'm trying to work on a function with multiple If(and) formulas, and I can't work out why my sum total isn't within the range of the formula. See below. CELL # Total Formula Result Proble...
=IF(AND(SUM($A$1:A1)>0,SUM($A$1:A1)<350), "A","B")
For the first part you can enter this formula in cell B1 and fill it down to B6. It returns the intended results in my sheet.
=IF(AND(SUM(A1:A6)>0,SUM(A1:A6)<350), "A","")&IF(AND(SUM(A1:A6)>0,SUM(A1:A6)<700), "A","B")
For the additional formula you can try this one in cell B6. The result is "A" in my sheet because the SUM(A1:A6) is 446.