SOLVED

Dividing Columns

%3CLINGO-SUB%20id%3D%22lingo-sub-2405747%22%20slang%3D%22en-US%22%3EDividing%20Columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2405747%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20an%20Excel%20form.%26nbsp%3B%20I%20want%20to%20divide%20columns%20c%2Fb%20and%20put%20them%20in%20column%20d.%26nbsp%3B%20T%20want%20to%20do%20this%20if%20columns%20b%20%26amp%3B%20c%20have%20values%20and%20do%20nothing%20if%20they%20are%20blank.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2405747%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2405809%22%20slang%3D%22en-US%22%3ERe%3A%20Dividing%20Columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2405809%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1068687%22%20target%3D%22_blank%22%3E%40alydar%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20are%20going%20to%20have%20to%20be%20a%20lot%20more%20precise%20about%20what%20it%20is%20that%20you%20want%20to%20do.%20What%20you've%20written%20so%20far%20doesn't%20make%20a%20lot%20of%20sense.%3C%2FP%3E%3CUL%3E%3CLI%3EWhat%20does%20%22divide%20columns%20c%2Fb%22%20mean%20in%20the%20first%20place%3F%3CUL%3E%3CLI%3EThey're%20already%20divided%20into%20two%20columns.%20Do%20you%20mean%20sum%20up%20and%20then%20divide%20by%20two%3F%20What%20do%20you%20mean%3F%3C%2FLI%3E%3C%2FUL%3E%3C%2FLI%3E%3CLI%3EWhat%20does%20%22put%20them%20in%20column%20D%22%20mean%2C%20given%20that%20D%20already%20is%20filled%3F%3CUL%3E%3CLI%3EOverwrite%20what's%20in%20D%3F%3C%2FLI%3E%3CLI%3EAdd%20a%20new%20column%20D%3F%3C%2FLI%3E%3C%2FUL%3E%3C%2FLI%3E%3CLI%3EYou%20wrote%20%22I%20want%20to%20do%20this%20if%20column%20B%26amp%3BC%20have%20values%22%3CUL%3E%3CLI%3E..do%20both%20have%20to%20have%20values%3F%20Or%20either%3F%3C%2FLI%3E%3CLI%3EWhat%20if%20only%20one%20has%20a%20value%3F%3C%2FLI%3E%3CLI%3E%5BIt%20does%20make%20a%20difference%2C%20you%20know.%5D%3C%2FLI%3E%3C%2FUL%3E%3C%2FLI%3E%3CLI%3E%22And%20do%20nothing%20if%20they%20are%20blank.%22%26nbsp%3B%26nbsp%3B%20%5Bredundant%2C%20since%20if%20they%20are%20blank%2C%20there's%20nothing%20to%20do%2C%20but%20we'll%20let%20that%20pass%5D%3C%2FLI%3E%3C%2FUL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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.

4 Replies

@alydar 

 

You are going to have to be a lot more precise about what it is that you want to do. What you've written so far doesn't make a lot of sense.

  • What does "divide columns c/b" mean in the first place?
    • They're already divided into two columns. Do you mean sum up and then divide by two? What do you mean?
  • What does "put them in column D" mean, given that D already is filled?
    • Overwrite what's in D?
    • Add a new column D?
  • You wrote "I want to do this if column B&C have values"
    • ..do both have to have values? Or either?
    • What if only one has a value?
    • [It does make a difference, you know.]
  • "And do nothing if they are blank."   [redundant, since if they are blank, there's nothing to do, but we'll let that pass]

 

I want  starts divided by wins to get a winning percentage for each of the 3 categories.

best response confirmed by alydar (New Contributor)
Solution

@alydar 

 

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.

Thanks. It worked.