Help Creating a Function in Excel

K

kmatthews

I'm trying to do something in Excel and I can't figure it out - maybe
it can't do it ... I have a spreadsheet with a list of calculated ages
.... I'm trying to get a new column to automatically show the word
"navigator" if the age in R8=6,7,8,9 but if the age in R8=10,11,12 I
want the new column to show "The Edge"

Any help would be appreciated ...

km
 
R

RichardSchollar

Hi

Possibly something like:

=LOOKUP(R8,{0,"";6,"Navigator";10,"The Edge"})

Hope this helps!

Richard
 
Top