Forum Discussion
alydar
Jun 01, 2021Copper Contributor
Dividing Columns
I have an Excel form. I want to divide columns c/b and put them in column d. T want to do this if columns b & c have values and do nothing if they are blank.
- Jun 01, 2021
Well, that's a start. Hardly a "win"
You did see that there were a few other questions, right?
If all you want is the formula, it would be =B3/C3 for the first row with data. Then copy that formula down. I'll leave it to you to deal with the exceptions. If you really want help, you can help others help you by answering the questions you've left unanswered.
mathetes
Jun 01, 2021Gold Contributor
Well, that's a start. Hardly a "win"
You did see that there were a few other questions, right?
If all you want is the formula, it would be =B3/C3 for the first row with data. Then copy that formula down. I'll leave it to you to deal with the exceptions. If you really want help, you can help others help you by answering the questions you've left unanswered.
alydar
Jun 06, 2021Copper Contributor
Thanks. It worked.