oh no, unforseen problem with a formula
 

The problem is if I want to print out the blank form. The formula I'm using
is =100-(COUNTIF(C8:AF8,"No")*10)
But if I erase all the info from the form so I can print it out blank, the
totals
stay 100 and I want those cells to be blank until info is entered. How can I
do that?
Yikes...

oh no, unforseen problem with a formula
 

We can use a "if blank then blank" approach

=IF(COUNTA(C8:AF8)=0,"",100-(COUNTIF(C8:AF8,"No")*10))

Simply put, if there is no data, display blank.
If there is data, use the formula.
--
Gary's Student
gsnu200701


"Meenie" wrote:

The problem is if I want to print out the blank form. The formula I'm using
is =100-(COUNTIF(C8:AF8,"No")*10)
But if I erase all the info from the form so I can print it out blank, the
totals
stay 100 and I want those cells to be blank until info is entered. How can I
do that?
Yikes...

oh no, unforseen problem with a formula
 

It would help if you stayed with one thread
Try something like =IF(COUNTA(C8:AF8)0,100-(COUNTIF(C8:AF8,"No")*10) , "")
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Meenie" wrote in message
...
The problem is if I want to print out the blank form. The formula I'm
using
is =100-(COUNTIF(C8:AF8,"No")*10)
But if I erase all the info from the form so I can print it out blank, the
totals
stay 100 and I want those cells to be blank until info is entered. How can
I
do that?
Yikes...

oh no, unforseen problem with a formula
 

Oops sorry, I thought no one would find a new questions buried inside a
thread :)
Thanks for your help, it's great!
"Bernard Liengme" wrote:

It would help if you stayed with one thread
Try something like =IF(COUNTA(C8:AF8)0,100-(COUNTIF(C8:AF8,"No")*10) , "")
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Meenie" wrote in message
...
The problem is if I want to print out the blank form. The formula I'm
using
is =100-(COUNTIF(C8:AF8,"No")*10)
But if I erase all the info from the form so I can print it out blank, the
totals
stay 100 and I want those cells to be blank until info is entered. How can
I
do that?
Yikes...

oh no, unforseen problem with a formula
 

Both of these formulaes work well, is there a reason one would be better than
the other?

"Bernard Liengme" wrote:

It would help if you stayed with one thread
Try something like =IF(COUNTA(C8:AF8)0,100-(COUNTIF(C8:AF8,"No")*10) , "")
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Meenie" wrote in message
...
The problem is if I want to print out the blank form. The formula I'm
using
is =100-(COUNTIF(C8:AF8,"No")*10)
But if I erase all the info from the form so I can print it out blank, the
totals
stay 100 and I want those cells to be blank until info is entered. How can
I
do that?
Yikes...

oh no, unforseen problem with a formula
 

Thank you, ""Gary"s Student" :)
I appreciate your help!

"Gary''s Student" wrote:

We can use a "if blank then blank" approach

=IF(COUNTA(C8:AF8)=0,"",100-(COUNTIF(C8:AF8,"No")*10))

Simply put, if there is no data, display blank.
If there is data, use the formula.
--
Gary's Student
gsnu200701


"Meenie" wrote:

The problem is if I want to print out the blank form. The formula I'm using
is =100-(COUNTIF(C8:AF8,"No")*10)
But if I erase all the info from the form so I can print it out blank, the
totals
stay 100 and I want those cells to be blank until info is entered. How can I
do that?
Yikes...

oh no, unforseen problem with a formula
 

One check if there are some entries, the other checks if there are no
entries.
Is the glass half-full or half-empty?
There is nothing to choose between the two formulas
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Meenie" wrote in message
...
Both of these formulaes work well, is there a reason one would be better
than
the other?

"Bernard Liengme" wrote:

It would help if you stayed with one thread
Try something like =IF(COUNTA(C8:AF8)0,100-(COUNTIF(C8:AF8,"No")*10) ,
"")
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Meenie" wrote in message
...
The problem is if I want to print out the blank form. The formula I'm
using
is =100-(COUNTIF(C8:AF8,"No")*10)
But if I erase all the info from the form so I can print it out blank,
the
totals
stay 100 and I want those cells to be blank until info is entered. How
can
I
do that?
Yikes...

oh no, unforseen problem with a formula
 

Well, just when you think it's safe to go in the water.....
I used this formula: =100-(COUNTIF(C8:AF8,"No")*10)
and thought it worked great but then discovered some people
used "N" for no and some typed out "No" for no. How do I make it work for
both?
I tried using "if" in there a couple of different ways, but I'm doing
something wrong. Excel keeps yelling
at me :)

"Bernard Liengme" wrote:

It would help if you stayed with one thread
Try something like =IF(COUNTA(C8:AF8)0,100-(COUNTIF(C8:AF8,"No")*10) , "")
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Meenie" wrote in message
...
The problem is if I want to print out the blank form. The formula I'm
using
is =100-(COUNTIF(C8:AF8,"No")*10)
But if I erase all the info from the form so I can print it out blank, the
totals
stay 100 and I want those cells to be blank until info is entered. How can
I
do that?
Yikes...

oh no, unforseen problem with a formula
 

This worked for me, let me know.
=100-(COUNTIF(C8:AF8,"N*")*10)

--
--
-John
Please rate when your question is answered to help us and others know what
is helpful.

"Meenie" wrote in message
...
Well, just when you think it's safe to go in the water.....
I used this formula: =100-(COUNTIF(C8:AF8,"No")*10)
and thought it worked great but then discovered some people
used "N" for no and some typed out "No" for no. How do I make it work for
both?
I tried using "if" in there a couple of different ways, but I'm doing
something wrong. Excel keeps yelling
at me :)

"Bernard Liengme" wrote:

It would help if you stayed with one thread
Try something like =IF(COUNTA(C8:AF8)0,100-(COUNTIF(C8:AF8,"No")*10) ,
"")
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Meenie" wrote in message
...
The problem is if I want to print out the blank form. The formula I'm
using
is =100-(COUNTIF(C8:AF8,"No")*10)
But if I erase all the info from the form so I can print it out blank,
the
totals
stay 100 and I want those cells to be blank until info is entered. How
can
I
do that?
Yikes...

oh no, unforseen problem with a formula
 

Hi John,
I'm sorry, I missed this when you wrote it ... but I don't think it would've
quite done the job because one of the answers is also N/A and I wouldn't want
it to count that.
Thanks :)

"John Bundy" wrote:

This worked for me, let me know.
=100-(COUNTIF(C8:AF8,"N*")*10)

--
--
-John
Please rate when your question is answered to help us and others know what
is helpful.

"Meenie" wrote in message
...
Well, just when you think it's safe to go in the water.....
I used this formula: =100-(COUNTIF(C8:AF8,"No")*10)
and thought it worked great but then discovered some people
used "N" for no and some typed out "No" for no. How do I make it work for
both?
I tried using "if" in there a couple of different ways, but I'm doing
something wrong. Excel keeps yelling
at me :)

"Bernard Liengme" wrote:

It would help if you stayed with one thread
Try something like =IF(COUNTA(C8:AF8)0,100-(COUNTIF(C8:AF8,"No")*10) ,
"")
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Meenie" wrote in message
...
The problem is if I want to print out the blank form. The formula I'm
using
is =100-(COUNTIF(C8:AF8,"No")*10)
But if I erase all the info from the form so I can print it out blank,
the
totals
stay 100 and I want those cells to be blank until info is entered. How
can
I
do that?
Yikes...