| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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... |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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... |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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... |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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... |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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... |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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... |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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... |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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... |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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... |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find value in array | Excel Worksheet Functions | |||
| Is it possible? | Excel Worksheet Functions | |||
| formula percentage problem | New Users to Excel | |||
| problem with Array Formula | Excel Worksheet Functions | |||
| Problem with VBA returning the contents of a long formula. | Excel Discussion (Misc queries) | |||
Linear Mode
