Thread: Function to add 3 column (of YES) to give a total % complete
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Eduardo Eduardo is offline
external usenet poster
  
Posts: 2,276
Default Function to add 3 column (of YES) to give a total % complete
Hi,
try

=IF(AND(a1="YES",a2="YES",a3="YES"),"100%",IF(AND( a1="YES",a2="YES"),"70%",IF(a1="YES","40%","")))

"preyesone" wrote:

I am trying to write a formula that will allow me to add a Yes to one cell
(in 3 different columns) cell and then give a % as the answer
For example:

Cell A1 = Yes Total would be 40%
Cell A2 = Yes Combined (A1+A2) Total would be 70%
Cell A3 = Yes Combined (A1+A2+A3) Total would be 100%

Any and all help is appreciated!
Reply With QuoteReply With Quote