When I create an IF/THEN formula, it will not give me good results if I use a sum function / a number as the THEN result.
This works:
=IF(AND(C122=0,C125>=17,SUM(C125:C128)=21,C128=0),1,0)
But this doesn't work:
=IF(AND(C122=0,C125>=17,SUM(C125:C128)=21,C128=0),1,SUM(C123:C125)/21))
I have attached my spreadsheet for your review. On row 140, the peach colored cell (E140) works. I need the blue cell (F140) to work. Your thoughts?ANDERSON Chemotherapy Orders and Independent Verification Audit Sheet WHAT.xlsx
Bookmarks