cfarrell93
New Member
- Joined
- Jun 23, 2016
- Messages
- 5
I'm trying to create a macro that will insert a formula into Column D and fill all the way down the column. The formula is a series of IF statements referencing the corresponding cell in Column C.
The formula I would like to insert is the following:
=IF(C2="G1","Generic Activity",IF(C2="D2","Delivered",IF(C2="E1","Exception",IF(C2="O1","Picked Up",IF(C2="G1","Generic Activity",IF(C2="D1","Delivered",IF(C2="M2","Manifested",IF(C2="M1","Manifested",""))))))))
I have tried to do this a few ways using information from other threads, but I continue to get error messages and bugs because of the formula. I think it's because of text within the IF statements ("G1", "Generic Activity, "E1", "Exception", etc.)
Any advice is much appreciated! Thanks in advance.
The formula I would like to insert is the following:
=IF(C2="G1","Generic Activity",IF(C2="D2","Delivered",IF(C2="E1","Exception",IF(C2="O1","Picked Up",IF(C2="G1","Generic Activity",IF(C2="D1","Delivered",IF(C2="M2","Manifested",IF(C2="M1","Manifested",""))))))))
I have tried to do this a few ways using information from other threads, but I continue to get error messages and bugs because of the formula. I think it's because of text within the IF statements ("G1", "Generic Activity, "E1", "Exception", etc.)
Any advice is much appreciated! Thanks in advance.