Posted to microsoft.public.excel.worksheet.functions

BenjieLop

Posts: n/a

Greater than, smaller than formula

alexander_geoff Wrote:
When grading children's test scores I want to apply letters and numerals
to particular ranges eg between 21 and 25=3c 26and 30=3b. Please help
with a formula.

You can do this ...

In Columns A and B, you can enter the following:

Cell A1 : 21 Cell B1: 3a
Cell A2 : 26 Cell B2: 3b
Cell A3: 31 Cell B3: 3c

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
Formula Problem - interrupted by #VALUE! in other cells!?	Ted	Excel Worksheet Functions	17	November 25th 05 05:18 PM
Formula which is greater tahn or equal to zero	bruce2444	Excel Worksheet Functions	2	September 7th 05 12:24 PM
Formula checking multiple worksheets	sonic-the-mouse	Excel Worksheet Functions	2	June 5th 05 07:48 PM
Formula checking multiple worksheets	sonic-the-mouse	Excel Worksheet Functions	2	June 5th 05 03:28 AM
Need a formula to determine the greater of a or b...	sonyav	Excel Discussion (Misc queries)	2	March 17th 05 08:13 PM

All times are GMT +1. The time now is 01:36 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us