=IF(AND(B2="Amount",C2<>0),C2,IF(AND(B2="Amount",C2=0,H2<>0),"DIRECT",9))
Hi, Im trying to incorporate the above formula into a macro (below) but am
having
some problems with the elses and nesting.
For i = 1 to 100
f Cells(i, 2) = "Amount" Then
If Cells(i, 3) <> 0 Then
Cells(i, 10) = Cells(i, 3)
Else
Cells(i, 10) = ".5"
End If
End If
End Sub
3. multiple ifs ands & indirect or offset?
6. Anzac Day symbols (for Australia ands New Zealands users)
8. Need help sorting out ANDs and ORs in parameter query
10. how to combine and's with or's in a if statement
11. if & ands and either indirect or offset - need help fast pleas
12. multiple ifs & ands indirect/offset...need help desperately pl
13. SUMPRODUCT with AND's and OR's?
14. Nesting IF's and AND's - a bit of help please...