IF Condition To Check Whether Absolute Value Is Greater Than Other Absolute Values

**aaron.mendes** · 07-08-2013, 05:30 PM

**Excel Fox** · 07-08-2013, 07:11 PM

You don't need a greater than or lesser than conditional VBA. You can just build a formula using VBA instead, and use it in column W (or the last empty column)

Code:

Sub GetErrorOK()

    With Worksheets("ccm_dispute_results")
        .Range("W2:W" & .Cells(.Rows.Count, 1).End(xlUp).Row).Formula = "=IF(OR(ABS(N2)>ABS(R2),ABS(N2)>ABS(M2)),""Error"",""OK"")"
    End With
    
End Sub

Anyway, since your query was Excel related, moving this thread to the Excel Help section. Also, please try to give a more meaningful and concise thread title, so that other people looking for similar solutions will be able to get search results from search engines. This can only happen if the thread title used is apt.

**aaron.mendes** · 07-08-2013, 10:34 PM

Hi, thanks for the code and renaming the Thread title appropriately.
But why would it throw an error for rows 33,36,37,39 where the numbers match for column N and Column M?

**aaron.mendes** · 07-08-2013, 10:40 PM

I guess it is due to column R being blank. But there will be many times where my column R will be blank. i.e. Zero amount.

**Excel Fox** · 07-08-2013, 10:46 PM

What would you want to do in that case?

**aaron.mendes** · 07-08-2013, 10:54 PM

I would still want the same result but keeping in mind that R column would be blank at some ocassions. Would that be possible?

**Excel Fox** · 07-08-2013, 11:28 PM

But a zero value N column is possible. I think my formula above should work.

EDIT: I posted the above without knowing OP had responded.

The queries regarding pivot table an mailing is digressing from the original question. So please start a new thread for that.

**Excel Fox** · 07-08-2013, 10:59 PM

OK, so if R is empty (actually, your sheet is showing zeroes, not blanks), then you want the formula to ignore that condition, right? And what about column M? What if that is also empty?

**aaron.mendes** · 07-08-2013, 11:08 PM

But i can sometimes have column N Blank (Zeroes).

**aaron.mendes** · 07-08-2013, 11:18 PM

Just want to summarize.

N column which is the amount should not be greater than any of the columns (M or R) irrespective of the signs (-ve or +ve) or Zeroes/Blanks in the columns.