-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
n/as
-
M
IF statement not wanting to see N/As
=IF(I119="1",E119+J119,0) with this formula, if the value doesn't show up, instead of seeing N/A's how would i make it so I see "-"'s instead?- mjoyce1994
- Thread
- formula make n/as show statement
- Replies: 1
- Forum: Excel Questions
-
S
Scorecard Help
Hello I am in need of some help when adding the overall grade as well as grade weights. Right now I have N/A's (Column P-R) defaulting to 1 if there is no grade.I am afraid this is still not correct. I think the grade is being over inflated with N/A's making the supplier's grade look better...- Star1566
- Thread
- grade making n/as suppliers weights
- Replies: 1
- Forum: Excel Questions
-
D
Remove N/A and 0s from Column
Hi There I have a data range B2:B129 and I would like to delete N/As and 0s from it just to show that these cells are blank Any help on this would be very much appreciated Regards Donal- Donal28
- Thread
- appreciated blank cells donal n/as
- Replies: 4
- Forum: Excel Questions
-
G
Power BI dealing with N/As
Hi all, My dataset includes a column for the size of a property (in square metres). For a minority of the properties, this column shows an N/A. I need to use this column in measures, for example total property size, and then segment in a visual by say region. In order to make that work I need...- gazpage
- Thread
- column n/a n/as properties size
- Replies: 3
- Forum: Power Tools
