Get instant live expert help on How do I define n/a
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
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