Converting Letter Grade to Numerical Value
 

I am using VLOOKUP to convert letter grades to numerical grades. I need to
avoid generating #N/A and just have a blank cell when a cell does not contain
a letter grade; e.g.

Letter Grade Column Returned Numercial Grade
A 1
B 2
(At the moment using VLOOKUP
generates #N/A
E 5

Many thanks

Converting Letter Grade to Numerical Value
 

=If(ISNA(your formula),"",your formula)
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Nick Horn" wrote in message
...
I am using VLOOKUP to convert letter grades to numerical grades. I need
to
avoid generating #N/A and just have a blank cell when a cell does not
contain
a letter grade; e.g.

Letter Grade Column Returned Numercial Grade
A 1
B 2
(At the moment using VLOOKUP
generates #N/A
E 5

Many thanks

Converting Letter Grade to Numerical Value
 

Many thanks

"ragdyer" wrote:

=If(ISNA(your formula),"",your formula)
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Nick Horn" wrote in message
...
I am using VLOOKUP to convert letter grades to numerical grades. I need
to
avoid generating #N/A and just have a blank cell when a cell does not
contain
a letter grade; e.g.

Letter Grade Column Returned Numercial Grade
A 1
B 2
(At the moment using VLOOKUP
generates #N/A
E 5

Many thanks

Converting Letter Grade to Numerical Value
 

Thanks for the feed-back.
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"Nick Horn" wrote in message
...
Many thanks

"ragdyer" wrote:

=If(ISNA(your formula),"",your formula)
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Nick Horn" wrote in message
...
I am using VLOOKUP to convert letter grades to numerical grades. I need
to
avoid generating #N/A and just have a blank cell when a cell does not
contain
a letter grade; e.g.

Letter Grade Column Returned Numercial Grade
A 1
B 2
(At the moment using VLOOKUP
generates #N/A
E 5

Many thanks