"If-If Else Help"

  • Thread starter Thread starter Jim Badinger
  • Start date Start date
J

Jim Badinger

How can I get the desired result?Treat the alpha/numeric
examples (A2, B2 & C2) as the cells themselves (as you
view an Exel Workbook). The first comparison is to see if
A2 is equal to B2, if they are equal to each other then
the text Finish would appear in cell C2. If they are not
equal to each other then the next comparison would be to
see if A2 is greater than B2 and if it is then A2 - B2 =
C2 (Ex: A2 = 120.00, B2 = 115.05, thus C2 = 4.95). Lastly,
if the two previous conditions do not exist then the cell
C2 displays "N/A". I also desire for this to be able to
function in succesive cells (copy & paste function).


If A2 = B2 Then
C2 = "FINISH"
ElseIf A2 > B2 Then
A2 -B2 = C2
Else
C2 = "NA"
End If

Thanks
JG Badinger
 
Back
Top