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
|