“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

I have define 3 ranges per cell as:
1 = Satisfactory
0= Unaceptable
N/A= No Applicable
I want to SUM the cells and when the SUM of all cells is N/A I want to set up as 100%, if the sum of all cells is 1 and if the sum of al cells is "0" provide me 0%.
Permits/Authorizations Used 100%
0101 Part A Work details N/A
0102 Part B Work scope & description N/A
0103 Part C Specialty safety equipment 1
0104 Part D Safety precautions N/A

Solved by I. S. in 25 mins

how to define date in excel is equal one

Solved by E. J. in 25 mins

I need a formula to take define name values and sum them together.
ie: GSDC=18 GSDI=30 in define name range. There will be four columns with different defined names to values to be added together.

Solved by X. W. in 18 mins

I need to define a formula in spreadsheet wherein it fetch cell values from a separate sheet and shows me if the cell is populated or not, but I don't want to define range instead want to go with text. Is it possible?

Solved by I. Q. in 18 mins

error 1004 application defined objective define

Solved by V. H. in 21 mins