Help for excel, calculate division of colums by sums

AI Thread Summary
To calculate the division of values in Excel, a column (J5:J35) is needed where each cell contains the result of dividing the corresponding value in column E by the sum of values in columns E and F (H). The formula for each cell in column J should be J = E / (E + F), which translates to J = E / H. Issues arise when using the "add function" feature, resulting in incorrect outputs of 1 or 0 due to integer formatting. To resolve this, ensure that the cells are formatted as float or double. Alternatively, a VBA macro can be used to automate the calculation, iterating through the rows and performing the division, storing the results in column J. This method ensures accurate results without manual entry.
late347
Messages
300
Reaction score
15
I have column from E5 -->E35 which contains values for each box.
another column from F5-->F35 contains values for each box

I have a sums column, H5-->H35,, which contains values for the sums between the E and F boxes (E5+F5=H5 ;;; E6+F6=H6 etc...)

I want a division column inside J5-->J35 which contains division such that the dividend = E column and the divisor = H column.
the division should be located inside the J column (J5-->J35) ##J= \frac{E}{E+F}=\frac{E}{H}##
 
Computer science news on Phys.org
i tried to add function from the "add function" button and "division" but it did not seem to work.

When I drag down the division function, then I only get 1 and 0 as the results of division, even though it is wrong to say that 1/6 = 0
 
I think I got it done by writing manually into the box what the function would be
 
late347 said:
i tried to add function from the "add function" button and "division" but it did not seem to work.
When I drag down the division function, then I only get 1 and 0 as the results of division, even though it is wrong to say that 1/6 = 0
1/0's are results of integer type so the cells need to be either float or double formatted.
You can also assign your buttons macros. Something simple like this
JavaScript:
Sub Division()
Dim answer As Double
For i = 5 To 35
    answer = Cells(i, "E").Value / (Cells(i, "E").Value + Cells(i, "F").Value)
    Cells(i, "J").Value = answer
Next i
End Sub
Now you can insert code similarly for H formula.
 
I came across a video regarding the use of AI/ML to work through complex datasets to determine complicated protein structures. It is a promising and beneficial use of AI/ML. AlphaFold - The Most Useful Thing AI Has Ever Done https://www.ebi.ac.uk/training/online/courses/alphafold/an-introductory-guide-to-its-strengths-and-limitations/what-is-alphafold/ https://en.wikipedia.org/wiki/AlphaFold https://deepmind.google/about/ Edit/update: The AlphaFold article in Nature John Jumper...
Thread 'Urgent: Physically repair - or bypass - power button on Asus laptop'
Asus Vivobook S14 flip. The power button is wrecked. Unable to turn it on AT ALL. We can get into how and why it got wrecked later, but suffice to say a kitchen knife was involved: These buttons do want to NOT come off, not like other lappies, where they can snap in and out. And they sure don't go back on. So, in the absence of a longer-term solution that might involve a replacement, is there any way I can activate the power button, like with a paperclip or wire or something? It looks...

Similar threads

3
Replies
100
Views
11K
3
Replies
105
Views
14K
Replies
2
Views
3K
Replies
4
Views
4K
Replies
1
Views
4K
Back
Top