See reply to your other post, as well as Bernard's above - please do
not multi-post.

Check your data. Are your values true numbers, or could they be text
that just looks like numbers?

Pete

On Feb 29, 3:31*am, JBG wrote:
Sorry about the confusion about rows and columns. *When I tried the formula
it resulted to 0. *When I look at the data it should be 100%. *Let me try it
again. Column D is 1/3 of the total percentage of column P. *The same with
column H and L. *So if Column D is larger than 4 and column H and L both are
negative numbers then P should be 33%. *The same if D and L were not met and
H was the same 33%. *If D and L both met their requirements it shold be 66%. *
The columns can be interchanged, but I hope that you are getting what I am
trying to do with this worksheet.
This is what makes since to me if all three columns are met then P should be
100% if one of the columns do not met their criteria then P should be 66% if
one column is met it is 33% and if no columns are met then P should be 0%. *
Does this help?
Joshua



"Bernard Liengme" wrote:
Not sure I get the question
If I do, then IF is not really needed
=(D14%)*33% + (H10)*33% + (L10)*33%
If I misunderstood, please give more detail
D is not a row but a column.
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"JBG" wrote in message
...
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.
I also did not want to create any rows that contained any information
other
than row P.- Hide quoted text -

- Show quoted text -