Nested IF formula statements

[janema]

I am using the following formula to return the value according to the below table:

=IF(G4<1.5,"needs improvement",IF(G4<2,"low meets",IF(G4<2.5,"meets",IF(G4<2.75,"exceeds",IF(G4>2.74,"high exceeds")))))

However, if the cell is ZERO, blank, or an error, I would like it to return a "N/A" value.

Can someone please help me to knows where to insert that and what ot use? I get an error when I do this way:

=IFERROR(IF(G4="","N/A",(G4<1.5,"needs improvement",IF(G4<2,"low meets",IF(G4<2.5,"meets",IF(G4<2.75,"exceeds",IF(G4>2.74,"high exceeds")))))

 

[janema]

I figured it out actually! Yay! Thanks anyway.

 

[awoohaw]

the function to return #N/A is NA().
But, your last argument should not be
G4>2.74,"high exceeds"
it should be:
G4>=2.75,"high exceeds"

 

[janema]

the function to return #N/A is NA().
But, your last argument should not be
G4>2.74,"high exceeds"
it should be:
G4>=2.75,"high exceeds"

You are right! Thanks so much! I missed that.