Excel Cross Tab IF Statements for Formatting

I have a crosstab query from an access database that I am exporting to excel.  I have been trying to formulate the IF clauses for all cells.  My data contains the following:

Vertical Access = SOX Controls
Horitonal Access = Projects
1 = Control Tested
0 = Control Not Tested
(blank) = No Control Available

I want to run the IF statement to change a 1 to "Tested", 0 to "Not Tested" and (blank cells) to "N/A" and grey them out.

I am using the following for the cells:

=IF(A2=1,"Tested",IF(A2=0,"Not Tested","N/A"))

Can anyone please help??
Who is Participating?
Patrick MatthewsConnect With a Mentor Commented:
=IF(A2=1,"Tested",IF(A2="","N/A","Not Tested"))

Then use Conditional Formatting to color the N/A cells.
Patrick MatthewsCommented:
BTW, if you are content to leave the blanks cells looking blank, you can make the 0 and 1 display as Not Tested and Tested, you could use this Customer number format:

[=1]"Tested";[=0]"Not Tested"
Rory ArchibaldCommented:
"Customer number format" - what Customer is this? :^P
Patrick MatthewsCommented:

custom number format :)
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.