Justin
asked on
DoLoop which populates column G with a Negative value if Number in Column E starts with 93.
Hi Guys, I am trying to do a Do Loop where I loop down Column E in a spreadsheet and if the number in the cell starts with "93",
it populates the cell 2 columns right of it in column G as a negative, eg: if Range "E2" = 937019784 and "G2" = 1000. It populates G2 as -1000.
If I had a Formula it would be =IF(LEFT(E2,2) = "93", G2*-1,G2).
it populates the cell 2 columns right of it in column G as a negative, eg: if Range "E2" = 937019784 and "G2" = 1000. It populates G2 as -1000.
If I had a Formula it would be =IF(LEFT(E2,2) = "93", G2*-1,G2).
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Why not use a formula?
ASKER
superb!
Open in new window