Thread: [Solved] Help Please!
View Single Post
 
Old 06-16-2016, 07:15 AM
sammielou sammielou is offline Windows 7 64bit Office 2013
Novice
 
Join Date: Feb 2016
Posts: 9
sammielou is on a distinguished road
Default Help Please!

I have attached a copy of an excel sheet that I'm currently working on. I'm trying to figure a formula that will set a score of 0 in C5 if there is a no entered in C2:C4. I currently have a countif entered in D4.

Also I need the formula to set a score of 50 in C5 if there are all yes' in C2:C4.

I'm sure this can be done, and I'm just over thinking this wayyy to much.


Thank you guys for any suggestions!
Attached Files
File Type: xlsx TEMP.xlsx (8.9 KB, 19 views)

Last edited by sammielou; 06-16-2016 at 07:45 AM. Reason: Figured It out!
Reply With Quote