If, then statements
 

Hi all, thanks for your help! I have two columns of 10 cells each that will
have percentages in them (already calculated). My results cell needs to say
"yes" if 90% or greater of these cells (18 out of 20) show =50%, "no" if 90%
of the cells show <50%. Also, the rows of cells are not next to each other,
they are D27:D36 and F27:F36. And sometimes F27:F36 will not have any results
in it (it will be "N/A"). Am I trying to do too much? Thanks!!!!

If, then statements
 

=SUM(COUNTIF(INDIRECT({"d27:D36","F27:F36"}),"0.5 "))

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"sarahz11" wrote in message
...
Hi all, thanks for your help! I have two columns of 10 cells each that
will
have percentages in them (already calculated). My results cell needs to
say
"yes" if 90% or greater of these cells (18 out of 20) show =50%, "no" if
90%
of the cells show <50%. Also, the rows of cells are not next to each
other,
they are D27:D36 and F27:F36. And sometimes F27:F36 will not have any
results
in it (it will be "N/A"). Am I trying to do too much? Thanks!!!!

If, then statements
 

Thanks Bob, but then how do I get it to say "yes" if the correct percentage
(90% of the entries) is =0.5? Also, it won't always be a minimum of 18, if
only one row is filled out, then to pass, it would just need 8.

"Bob Phillips" wrote:

=SUM(COUNTIF(INDIRECT({"d27:D36","F27:F36"}),"0.5 "))

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"sarahz11" wrote in message
...
Hi all, thanks for your help! I have two columns of 10 cells each that
will
have percentages in them (already calculated). My results cell needs to
say
"yes" if 90% or greater of these cells (18 out of 20) show =50%, "no" if
90%
of the cells show <50%. Also, the rows of cells are not next to each
other,
they are D27:D36 and F27:F36. And sometimes F27:F36 will not have any
results
in it (it will be "N/A"). Am I trying to do too much? Thanks!!!!

If, then statements
 

On Mar 20, 12:07 pm, sarahz11
wrote:
Thanks Bob, but then how do I get it to say "yes" if the correct percentage
(90% of the entries) is =0.5? Also, it won't always be a minimum of 18, if
only one row is filled out, then to pass, it would just need 8.



"Bob Phillips" wrote:
=SUM(COUNTIF(INDIRECT({"d27:D36","F27:F36"}),"0.5 "))

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"sarahz11" wrote in message
...
Hi all, thanks for your help! I have two columns of 10 cells each that
will
have percentages in them (already calculated). My results cell needs to
say
"yes" if 90% or greater of these cells (18 out of 20) show =50%, "no" if
90%
of the cells show <50%. Also, the rows of cells are not next to each
other,
they are D27:D36 and F27:F36. And sometimes F27:F36 will not have any
results
in it (it will be "N/A"). Am I trying to do too much? Thanks!!!!- Hide quoted text -

- Show quoted text -

I'd say you need to insert an interim results column, something like
=IF(d27=50%,if(f27=50%,1,0,0), or however you want to test the data
for the two columns. The nested IF statements would bring back a
value of 1 if both cells had values greater than 50%, otherwise 0.
Then your results formula refers to the interim results column and is
something like =IF(sum(interim column)=.
9*(count(d27:d36)+count(f27:f36)),"yes","no").

Good luck.
John

If, then statements
 

Awesome, thanks!

" wrote:

On Mar 20, 12:07 pm, sarahz11
wrote:
Thanks Bob, but then how do I get it to say "yes" if the correct percentage
(90% of the entries) is =0.5? Also, it won't always be a minimum of 18, if
only one row is filled out, then to pass, it would just need 8.



"Bob Phillips" wrote:
=SUM(COUNTIF(INDIRECT({"d27:D36","F27:F36"}),"0.5 "))

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"sarahz11" wrote in message
...
Hi all, thanks for your help! I have two columns of 10 cells each that
will
have percentages in them (already calculated). My results cell needs to
say
"yes" if 90% or greater of these cells (18 out of 20) show =50%, "no" if
90%
of the cells show <50%. Also, the rows of cells are not next to each
other,
they are D27:D36 and F27:F36. And sometimes F27:F36 will not have any
results
in it (it will be "N/A"). Am I trying to do too much? Thanks!!!!- Hide quoted text -

- Show quoted text -

I'd say you need to insert an interim results column, something like
=IF(d27=50%,if(f27=50%,1,0,0), or however you want to test the data
for the two columns. The nested IF statements would bring back a
value of 1 if both cells had values greater than 50%, otherwise 0.
Then your results formula refers to the interim results column and is
something like =IF(sum(interim column)=.
9*(count(d27:d36)+count(f27:f36)),"yes","no").

Good luck.
John