Thread: less than 0.5 but more than -0.5
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ctech[_27_] Ctech[_27_] is offline
external usenet poster
  
Posts: 1
Default 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

Reply With QuoteReply With Quote