Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula help - Sum results Pass or Fail
Need help with a formula.
Want to sum the total of a range of cells, then if it is less then a specific number the value should be "Fail", if greater then that number then value should be "Pass" I've used the And function True or False results. But they want the value in the cells to say either Pass or Fail. current formula: =AND(SUM(J8:R8)0,SUM(J8:R8)<8) Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula help - Sum results Pass or Fail
Try this:
=IF(SUM(J8:R8)<=8,"Fail","Pass") Is that something you can work with? -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "Nadine" wrote in message ... Need help with a formula. Want to sum the total of a range of cells, then if it is less then a specific number the value should be "Fail", if greater then that number then value should be "Pass" I've used the And function True or False results. But they want the value in the cells to say either Pass or Fail. current formula: =AND(SUM(J8:R8)0,SUM(J8:R8)<8) Thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula help - Sum results Pass or Fail
Tried that originally, but at the bottom of the column want a count for all
that say Fail Problem is when copy the formula down the column it sets all to Fail because there isn't any data entered yet, so the count value is wrong. As data will be entered daily, but there will be blank rows until the entire month is filled in. But need the count to reflect current count for any day that they look at it. So if the entire column says Fail, the count will be wrong. Not too sure how to work around that unless I put in default values in all the rows and columns, not wanting to do that as it will throw off the count for all the other columns. And not giving true totals. Is there a way to leave the pass/fail value blank until it has numbers in the cells to sum? "Ron Coderre" wrote: Try this: =IF(SUM(J8:R8)<=8,"Fail","Pass") Is that something you can work with? -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "Nadine" wrote in message ... Need help with a formula. Want to sum the total of a range of cells, then if it is less then a specific number the value should be "Fail", if greater then that number then value should be "Pass" I've used the And function True or False results. But they want the value in the cells to say either Pass or Fail. current formula: =AND(SUM(J8:R8)0,SUM(J8:R8)<8) Thanks |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula help - Sum results Pass or Fail
Perhaps this?
=IF(COUNT(J8:R8),IF(SUM(J8:R8)<=8,"Fail","Pass")," no data") Does that help? -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "Nadine" wrote in message ... Tried that originally, but at the bottom of the column want a count for all that say Fail Problem is when copy the formula down the column it sets all to Fail because there isn't any data entered yet, so the count value is wrong. As data will be entered daily, but there will be blank rows until the entire month is filled in. But need the count to reflect current count for any day that they look at it. So if the entire column says Fail, the count will be wrong. Not too sure how to work around that unless I put in default values in all the rows and columns, not wanting to do that as it will throw off the count for all the other columns. And not giving true totals. Is there a way to leave the pass/fail value blank until it has numbers in the cells to sum? "Ron Coderre" wrote: Try this: =IF(SUM(J8:R8)<=8,"Fail","Pass") Is that something you can work with? -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "Nadine" wrote in message ... Need help with a formula. Want to sum the total of a range of cells, then if it is less then a specific number the value should be "Fail", if greater then that number then value should be "Pass" I've used the And function True or False results. But they want the value in the cells to say either Pass or Fail. current formula: =AND(SUM(J8:R8)0,SUM(J8:R8)<8) Thanks |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula help - Sum results Pass or Fail
YES :-) that did the trick perfectly. Thank you thank you.. Been at this
for awhile now. I'll be adding this to my list of formula tips. "Ron Coderre" wrote: Perhaps this? =IF(COUNT(J8:R8),IF(SUM(J8:R8)<=8,"Fail","Pass")," no data") Does that help? -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "Nadine" wrote in message ... Tried that originally, but at the bottom of the column want a count for all that say Fail Problem is when copy the formula down the column it sets all to Fail because there isn't any data entered yet, so the count value is wrong. As data will be entered daily, but there will be blank rows until the entire month is filled in. But need the count to reflect current count for any day that they look at it. So if the entire column says Fail, the count will be wrong. Not too sure how to work around that unless I put in default values in all the rows and columns, not wanting to do that as it will throw off the count for all the other columns. And not giving true totals. Is there a way to leave the pass/fail value blank until it has numbers in the cells to sum? "Ron Coderre" wrote: Try this: =IF(SUM(J8:R8)<=8,"Fail","Pass") Is that something you can work with? -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "Nadine" wrote in message ... Need help with a formula. Want to sum the total of a range of cells, then if it is less then a specific number the value should be "Fail", if greater then that number then value should be "Pass" I've used the And function True or False results. But they want the value in the cells to say either Pass or Fail. current formula: =AND(SUM(J8:R8)0,SUM(J8:R8)<8) Thanks |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula help - Sum results Pass or Fail
I'm so glad I could help, Nadine.
Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "Nadine" wrote in message ... YES :-) that did the trick perfectly. Thank you thank you.. Been at this for awhile now. I'll be adding this to my list of formula tips. "Ron Coderre" wrote: Perhaps this? =IF(COUNT(J8:R8),IF(SUM(J8:R8)<=8,"Fail","Pass")," no data") Does that help? -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "Nadine" wrote in message ... Tried that originally, but at the bottom of the column want a count for all that say Fail Problem is when copy the formula down the column it sets all to Fail because there isn't any data entered yet, so the count value is wrong. As data will be entered daily, but there will be blank rows until the entire month is filled in. But need the count to reflect current count for any day that they look at it. So if the entire column says Fail, the count will be wrong. Not too sure how to work around that unless I put in default values in all the rows and columns, not wanting to do that as it will throw off the count for all the other columns. And not giving true totals. Is there a way to leave the pass/fail value blank until it has numbers in the cells to sum? "Ron Coderre" wrote: Try this: =IF(SUM(J8:R8)<=8,"Fail","Pass") Is that something you can work with? -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "Nadine" wrote in message ... Need help with a formula. Want to sum the total of a range of cells, then if it is less then a specific number the value should be "Fail", if greater then that number then value should be "Pass" I've used the And function True or False results. But they want the value in the cells to say either Pass or Fail. current formula: =AND(SUM(J8:R8)0,SUM(J8:R8)<8) Thanks |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula help - Sum results Pass or Fail
For a blank look.
=IF(COUNT(J8:R8),IF(SUM(J8:R8)<=8,"Fail","Pass")," ") Assumes the "Fail", "Pass" formulas are in column A To count the occurences of Pass or Fail =COUNTIF(A:A,"Fail") =COUNTIF(A:A,"Pass") Gord Dibben MS Excel MVP On Tue, 4 Mar 2008 12:48:06 -0800, Nadine wrote: Tried that originally, but at the bottom of the column want a count for all that say Fail Problem is when copy the formula down the column it sets all to Fail because there isn't any data entered yet, so the count value is wrong. As data will be entered daily, but there will be blank rows until the entire month is filled in. But need the count to reflect current count for any day that they look at it. So if the entire column says Fail, the count will be wrong. Not too sure how to work around that unless I put in default values in all the rows and columns, not wanting to do that as it will throw off the count for all the other columns. And not giving true totals. Is there a way to leave the pass/fail value blank until it has numbers in the cells to sum? "Ron Coderre" wrote: Try this: =IF(SUM(J8:R8)<=8,"Fail","Pass") Is that something you can work with? -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "Nadine" wrote in message ... Need help with a formula. Want to sum the total of a range of cells, then if it is less then a specific number the value should be "Fail", if greater then that number then value should be "Pass" I've used the And function True or False results. But they want the value in the cells to say either Pass or Fail. current formula: =AND(SUM(J8:R8)0,SUM(J8:R8)<8) Thanks |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula help - Sum results Pass or Fail
What whould be a proper way to make a formula sum a total of pass/ fail results.
Let say i have Total Pass: on C2 and line of pass/fail on b14:b573 Thank you On Tuesday, March 4, 2008 3:02:39 PM UTC-5, Ron Coderre wrote: Try this: =IF(SUM(J8:R8)<=8,"Fail","Pass") Is that something you can work with? -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "Nadine" wrote in message ... Need help with a formula. Want to sum the total of a range of cells, then if it is less then a specific number the value should be "Fail", if greater then that number then value should be "Pass" I've used the And function True or False results. But they want the value in the cells to say either Pass or Fail. current formula: =AND(SUM(J8:R8)0,SUM(J8:R8)<8) Thanks |
#9
|
|||
|
|||
What whould be a proper way to make a formula sum a total of pass/ fail results.
Let say i have Total Pass: on C2 and line of pass/fail on b14:b573 Thank you Quote:
|
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula help - Sum results Pass or Fail
this one works for school based users
Subject order: Home Lang, Sec Add Lang, Life Orient, Math/Mlit, PHS/ACC/HIST, Bust/Life Sc, Geog/ Econ. use excel. =IF(AND(D239,E229,F239,OR(G229,OR(OR(J229,L2 29,K229),OR(I229,M229),OR(N229,H229)))),"PASS ","FAIL")... test with various marks according to the pass requirements. Hope this will be helpful |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Templates Fail | Excel Discussion (Misc queries) | |||
How to calculate pass/fail percentages entered on a spreadsheet? | New Users to Excel | |||
Pass or Fail (green or red) criteria for cell? | Excel Discussion (Misc queries) | |||
Formula & functions intermittently fail to calculate | Excel Worksheet Functions | |||
pass fail | New Users to Excel |