less than 0.5 but more than -0.5
 

I have this formula now

Range("A2").FormulaR1C1 = _
"=IF(SUMIF(C[10],RC[10],C[11])=0,""SortLow"",""SortHigh"")"


How can I change this to take more than -0.5 and less than +0.5?


Thanks


--
Ctech
------------------------------------------------------------------------
Ctech's Profile: http://www.excelforum.com/member.php...o&userid=27745
View this thread: http://www.excelforum.com/showthread...hreadid=476249

less than 0.5 but more than -0.5
 

Range("A2").FormulaR1C1 = _
"=IF(ABS(SUMIF(C[10],RC[10],C[11]))<=0.5," & _
"""SortLow"",""SortHigh"")"


--
Regards,
Tom Ogilvy

"Ctech" wrote in
message ...

I have this formula now

Range("A2").FormulaR1C1 = _
"=IF(SUMIF(C[10],RC[10],C[11])=0,""SortLow"",""SortHigh"")"


How can I change this to take more than -0.5 and less than +0.5?


Thanks


--
Ctech
------------------------------------------------------------------------
Ctech's Profile:
http://www.excelforum.com/member.php...o&userid=27745
View this thread: http://www.excelforum.com/showthread...hreadid=476249