Using Rank function, how to show value as 'N/A' IF O
 

I have put an rank function in place which works as follows (column A in my
worksheet)

=RANK(AC3,AC$3:AC$134,0)

This works fine, except I want it to come up with a value of N?A if the
number in Column AC equals 0. So I tried the following (Column A on my
worksheet)

=IF(AC3="0","N/A",(RANK(AC3,AC$3:AC$134,0)))

This made absolutely no difference, all the 0 values still appear with a
number appearing instead of N/A.

Is there something glaringly obvious I am doing wrong?

Using Rank function, how to show value as 'N/A' IF O
 

You need to remove the "" from around the 0. If you have "" it wants text not
a number.

=IF(AC3=0,"N/A",(RANK(AC3,AC$3:AC$134,0)))
--
Hope this helps


"Alex" wrote:

I have put an rank function in place which works as follows (column A in my
worksheet)

=RANK(AC3,AC$3:AC$134,0)

This works fine, except I want it to come up with a value of N?A if the
number in Column AC equals 0. So I tried the following (Column A on my
worksheet)

=IF(AC3="0","N/A",(RANK(AC3,AC$3:AC$134,0)))

This made absolutely no difference, all the 0 values still appear with a
number appearing instead of N/A.

Is there something glaringly obvious I am doing wrong?

Using Rank function, how to show value as 'N/A' IF O
 

I ended up sorting it out, thanks anyway!

"JudithJubilee" wrote:

You need to remove the "" from around the 0. If you have "" it wants text not
a number.

=IF(AC3=0,"N/A",(RANK(AC3,AC$3:AC$134,0)))
--
Hope this helps


"Alex" wrote:

I have put an rank function in place which works as follows (column A in my
worksheet)

=RANK(AC3,AC$3:AC$134,0)

This works fine, except I want it to come up with a value of N?A if the
number in Column AC equals 0. So I tried the following (Column A on my
worksheet)

=IF(AC3="0","N/A",(RANK(AC3,AC$3:AC$134,0)))

This made absolutely no difference, all the 0 values still appear with a
number appearing instead of N/A.

Is there something glaringly obvious I am doing wrong?