Posted to microsoft.public.excel.misc

Jane

external usenet poster

Posts: 202

Excel cell conversion problem

To convert numbers into GCSE grades I need to use a formula that will read
down a column and if the cell content is between 1-7 to insert the letter U,
if the cell content is between 8-11 to insert the letter G, if the cell
content is between 12-15 to insert the letter F,etc

Any ideas?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Conversion problem	Keithp	Excel Discussion (Misc queries)	0	January 4th 07 11:01 AM
Date Conversion Problem	sixwest	Excel Discussion (Misc queries)	1	June 23rd 06 06:15 PM
Problem in Conversion	usm	Excel Discussion (Misc queries)	1	June 17th 06 05:32 PM
Excel Text Conversion Problem	Michael D	Excel Discussion (Misc queries)	0	March 14th 06 12:26 AM
Excel 97 to 2003 conversion problem	PaulC	Excel Discussion (Misc queries)	8	June 18th 05 12:12 PM

All times are GMT +1. The time now is 07:07 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us