| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Nesting ,Ands
=IF(AND(B2="Amount",C2<0),C2,IF(AND(B2="Amount",C 2=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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 3 ANDS + 1 OR | Excel Discussion (Misc queries) | |||
| Multiple Nested IFs, ORs, Ands | Excel Worksheet Functions | |||
| Multiple ifs, and ands, and are not working | Excel Discussion (Misc queries) | |||
| Ifs and Ands - I'm confused! | Excel Worksheet Functions | |||
| Conditional Statement with ANDs | Excel Discussion (Misc queries) | |||
Threaded Mode
