Mazzaropi

Senior Member

Location: Belo Horizonte, Brazil

Posts: 170

Quote:

Originally Posted by sumesh56

i have a worksheet. in which i have grades in col C. I want to get these grades converted into a value in col D. suppose grades are like this..
in C5=A1 C6=B1 C7= D1
i want to convert ----- A1 into 10 B1 into 8
AND D1 into 6. how can i accomplish this?

I´m not sure if I understood correctly your necessity.

Try to do this one: Cell D5 -- =IF(C5="A1",10,IF(C5="B1",8,6))

If it´s not what your looking for, try explain with a worksheet example here.

__________________
I hope it can help you.

Best regards,
Marcilio Lobão
---------------------------
Belo Horizonte, Brazil

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
How do I convert A-E grades to number averages?	Abigail	Excel Discussion (Misc queries)	18	March 23rd 08 11:38 PM
How to Weight Grades vs. Averaging Student Grades	Arnold[_3_]	Excel Programming	2	October 17th 07 10:56 PM
try to convert letter grades into GPA grade points	scabbage	Excel Worksheet Functions	3	October 22nd 05 05:31 AM
Grades	Michael L	Excel Worksheet Functions	2	October 4th 05 04:19 PM
Getting Grades	snax500[_2_]	Excel Programming	3	July 27th 04 05:45 AM

All times are GMT +1. The time now is 11:14 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us