Increase percent in cell if other cells contain data

[RichTea88]

I'm trying to track how complete a project is by checking if cells contain data, and if they do the percent in cell 'Y4' would increase.

I have 6 cells which represent milestones and if they contain data then they would add a certain percent to cell 'Y4'.

Cells B13 & R13 would have a weight of 15% each

Cells J13, J21 & J30 Would have a weight of 20%

Cell L34 would have a weight of 10%

Is there any way that if these cells contained any data that I could add that percent to the total in 'Y4'?

[flesem25]

You could use a bunch of if statements based on each individual cell and add them together,

=IF(B13="",0,0.15)+IF(R13="",0,0.15)+IF(J13="",0,0.2)+IF(J21="",0,0.2)+IF(J23="",0,0.2)+IF(L34="",0,0.1)

I tested it and it seems to work. copy and paste in Y4, and set the acutal cells to their respective cells.

[RichTea88]

Flesem, You Sir, are a gentleman and a scholar. I tip my hat to you.