less than 0.5 but more than -0.5

  • Thread starter Thread starter Ctech
  • Start date Start date
C

Ctech

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
 
Range("A2").FormulaR1C1 = _
"=IF(ABS(SUMIF(C[10],RC[10],C[11]))<=0.5," & _
"""SortLow"",""SortHigh"")"
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Best Way to Understand Extremely Dense Nested Ifs in Formulas 15
Number Format 1
Less than numbers issue please help 2
XL2007 : variable value changes unexpectedly 2
Formula 2
Changing playback rate of “Windows Media Player” control in C# for .wav files 0
Conditional format : return to default format 5
Delete rows based on more than one condition. 3

Back
Top