Hoping there is an Excell guru on the site as my colleagues have struck out!

looking to make a cell show a letter depending on the range of a result in another cell.

If I call the cell A1 I want A3 to show a letter

if A1 is between 1 and 6 I want cell A3 to show an I
if A1 is between 7 and 10 I want cell A3 to show an L
if A1 is between 11 and 19 I want cell A3 to show an M and
if A1 is between 20 and 25 I want cell A3 to show an H

Is this possible?

Much appreciate any help from the team!!

Regards

Steuart Now - MY11 RRS Autobiography TDV6, Orkney gray, tints, steps, daylight running lamps and allllll the toys!!!
Ex- RRS HSE TDV6 07 Java Black, bi xenon, corner lights, side steps, tints, cool box, smoke side repeats, chrome "sport" boot sill
Ex - Audi A4 Cab 3.0TDi Quattro
Ex - Freelander2 SE TD4
Ex - CRV Auto

Give that a go

=if(A1=MEDIAN(1:6),"I")

I wonder how many members will be scratching their heads after reading this

Damn, forum kept changing the formula......anyway, this should do it

Click image to enlarge

Im scratching mine and I can see the answers!!

Many thanks gents - I will try them later if I survive the next meeting!! Now - MY11 RRS Autobiography TDV6, Orkney gray, tints, steps, daylight running lamps and allllll the toys!!!
Ex- RRS HSE TDV6 07 Java Black, bi xenon, corner lights, side steps, tints, cool box, smoke side repeats, chrome "sport" boot sill
Ex - Audi A4 Cab 3.0TDi Quattro
Ex - Freelander2 SE TD4
Ex - CRV Auto

Beancounter_74 wrote:

Damn, forum kept changing the formula......anyway, this should do it

Click image to enlarge

ha ha - you're not called Beancounter for nothing  FF 4.4 V8 Soooo looking forward to this bad boy
Ex 2006 RRS SC - garbage
Ex 2016 135i M Sport - dream car
Ex 2003 RS6 Avant - piece of cr*p
Ex 2014 320d X Drive, M Sport Touring - ok I guess
Ex 2007 RRS TDV8 - bloody loved it
EX 2007 FL2 XS - not so bad

 ON THE WAY: BMW F21 M140i
MERCEDES GL350 - Metallic Navy Blue w/Grey interior

GOING: BMW F31 335D MSport+ xDrive Touring
GONE: Land Rover Discovery 4 HSE - Stornaway Grey w/Black Interior (wish we'd kept it )
GONE: BMW F10 520D MSport - Carbon Black
GONE:MY12 RRS SDV6 HSE Sumatra/Ivory/Grand Black Privacy glass

Well at least we now know who to contact as the resident Excel expert  MY2011 HSE Santorini/Ivory/Piano Black/Privacy Glass/TV .Sadly gone.
Audi A5 Sportback Black Edition 3.0 tdi quattro S Line

Ady 555 wrote:

I wonder how many members will be scratching their heads after reading this

And scratching other parts of ones anatomy  In Spain - 2018 F Pace - Frightened away from the Sports due to crank failures
Gone - A couple of RRS, A couple of Disco's. However thinking of another Sport.

http://spreadsheets.about.com/od/excelform..._begin.htm

^^^ None of that tutorial stuff needed here Ady, its all in the old grey matter  ON THE WAY: BMW F21 M140i
MERCEDES GL350 - Metallic Navy Blue w/Grey interior

GOING: BMW F31 335D MSport+ xDrive Touring
GONE: Land Rover Discovery 4 HSE - Stornaway Grey w/Black Interior (wish we'd kept it )
GONE: BMW F10 520D MSport - Carbon Black
GONE:MY12 RRS SDV6 HSE Sumatra/Ivory/Grand Black Privacy glass

Last edited by Beancounter_74 on Wed Feb 22 2012 5:35pm. Edited 1 time in total

Its ok for some, just trying to educate a few for those that are still scratching their anatomy

@ Ady
Happy to help if I can with anything Excel related. Don't use it so much nowadays, but spent WAY too long using it over the years.....all part of the job I suppose! ON THE WAY: BMW F21 M140i
MERCEDES GL350 - Metallic Navy Blue w/Grey interior

GOING: BMW F31 335D MSport+ xDrive Touring
GONE: Land Rover Discovery 4 HSE - Stornaway Grey w/Black Interior (wish we'd kept it )
GONE: BMW F10 520D MSport - Carbon Black
GONE:MY12 RRS SDV6 HSE Sumatra/Ivory/Grand Black Privacy glass

Cheers Mr been, i have all on learning english never mind excel