• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Re-distribution of weights - formula help needed ? (solved)

dimitrz

New Member
Dear experts ,
need help in creating a formula to redistribute weightage incase one of the Cell value is "n/a"

I have attached an excel file for ease of clarity

1693678982438.png
 

Attachments

  • weighted test.xlsx
    17.7 KB · Views: 10
I got an answer from a different forum
posting the formula here so that it may help others

=IF($H3="N/A","",$F3/SUMIF($H$3:$H$7,"<>N/A",$F$3:$F$7))
 

dimitrz

... incase one of the Cell value is "n/a" and later You wrote more
Your gotten solution seems to work even if none of cells is "n/a".
... but ...
if
more means everything then there will be a challenge.
 
Back
Top