Maybe I need a if/then statement
 

I have row D that needs to be over 4.00% to be counted 33%
Row H that needs to be a positive number to be counted 33%
Row L that needs to be a positive number to be counted 33%
and the sum of all three rows add in row P. The range could be 0%, 33%,
66%, or 100% I hope this makes since.

Maybe I need a if/then statement
 

I also did not want to create any rows that contained any information other
than row P.

"JBG" wrote:

I have row D that needs to be over 4.00% to be counted 33%
Row H that needs to be a positive number to be counted 33%
Row L that needs to be a positive number to be counted 33%
and the sum of all three rows add in row P. The range could be 0%, 33%,
66%, or 100% I hope this makes since.

Maybe I need a if/then statement
 

You are getting rows and columns mixed up - columns are referred to by
letter. Assuming you want to start this on row 2, then try this in P2:

=(D20.04)/3 + (H20)/3 + (L20)/3

Format the cell as percentage, then copy down as required.

Hope this helps.

Pete

On Feb 28, 11:10*pm, JBG wrote:
I also did not want to create any rows that contained any information other
than row P.



"JBG" wrote:
I have row D that needs to be over 4.00% to be counted 33%
Row H that needs to be a positive number to be counted 33%
Row L that needs to be a positive number to be counted 33%
and the sum of all three rows add in row P. *The range could be 0%, 33%,
66%, or 100% *I hope this makes since.- Hide quoted text -

- Show quoted text -