jardenp
Active Member
- Joined
- May 12, 2009
- Messages
- 373
- Office Version
- 2019
- 2016
- 2013
- 2011
- 2010
- Platform
- Windows
I would like VBA code that evaluates A1 according to the formula LEFT(A1,3)="Ven". If it is true, I want B1, C1, and D1 to remain blank. If it is false, then it applies these formulas: in B1, "=F1*4"; in C1, "=G1*4"; and in D1, "=H1*4".
It would apply this IF/THEN to all rows in the sheet.
I know how to do this with IF formulas, but I need the B, C, and D cells to remain blank if A starts with "Ven" because I want the full A cell text string to display. If there is any formula in B,C, or D, the text display is cut off, even when I set the cell value to "" in the IF formula and then cut and paste for values only. I can't widen column A because it would be too wide.
Another alternative would be to fill in with IF formulas, copy/paste to values and then somehow delete the B,C, and D cells for all rows where the A cell started with "Ven".
Any help would be greatly appreciated.
It would apply this IF/THEN to all rows in the sheet.
I know how to do this with IF formulas, but I need the B, C, and D cells to remain blank if A starts with "Ven" because I want the full A cell text string to display. If there is any formula in B,C, or D, the text display is cut off, even when I set the cell value to "" in the IF formula and then cut and paste for values only. I can't widen column A because it would be too wide.
Another alternative would be to fill in with IF formulas, copy/paste to values and then somehow delete the B,C, and D cells for all rows where the A cell started with "Ven".
Any help would be greatly appreciated.