| 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 |
| 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 | |||
Threaded Mode
