Writing Multiple If functions

[aackerm]

I think I need to do this in VBA but I have no idea. Here's what I need; to compare numbers in two different cells based on multiple arguments. For example, if the number in A1 is <20 and the number in B1 is >=60 then C1 Shows "Pass", if A1 = 21 and B1 is >= 61 then C1 shows "Pass". I need to extend this argument all the way to if A1 = 100. Any assistance would greatly be appreciated.

 

[rayk8301]

=if(A1<20,"pass",if(A1>=60,"pass",if(A1=21,"pass",if(B1>=61,"pass","failed"))))

hope this helps

 

[mikerickson]

Perhaps

If 60 + WorksheetFunction.Max(0, (Range("A1").Value - 20)) <= Range("B1") Then
    MsgBox "pass"
Else
    MsgBox "fail"
End If

 

[aackerm]

I should add that the scale changes once the number in A1 reaches 62. Example: if A1 =62 and B1 <= 81 then C1 shows "Pass", if A1=63 and B1<=82 the C1 shows "Pass", if A1 =64 and B1 <=82 then C1 shows "Pass"... if A1 = 95 and B1 <= 98 then C1 shows "Pass".