LinkBack URL
About LinkBacks
Row 1 : 0.2,0.2,0.3,0.3
Row 2: 0,1,0,3
Row 2 to be increases based on row 1 percentages. If row 2 has a 0 value, the percentage should be readjusted and so the row 2 value
Row 1 : 0.2,0.2,0.3,0.3
Row 2: 0,1,0,3
Row 2 to be increases based on row 1 percentages. If row 2 has a 0 value, the percentage should be readjusted and so the row 2 value
I am not sure I follow you. Could you perhaps explain a bit more, or even upload a workbook example.
Cheers,
berlan
Row 3: 0.2*0 ,0.2*1,0.3*0,0.3*3
Looking for an option to readjust the percentages lost to those that has values.ie 0.2 and 0.3 needs to be reapplied to those that had values.
Hi
Well the simple
Formula:
=A1*A2
in row 3 will produce the results for which you are showing a calculation but I'm by no means certain that's what you're asking because of your mention of some readjustment. In which case please clarify further with a worked example containing manually created results.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks