About Us

sumesh56

Quote:

Originally Posted by Mazzaropi

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.

let me check it and tell whether it works or not,. btw, i got an idea to do this using the vlookup funtion. but yours seems to be simple compared to that . let me see. thanks for the suggestion. have a nice day.

sumesh56

Quote:

Originally Posted by sumesh56

let me check it and tell whether it works or not,. btw, i got an idea to do this using the vlookup funtion. but yours seems to be simple compared to that . let me see. thanks for the suggestion. have a nice day.

thanks a lot for this suggestion. it works perfectly. this is what i wanted.have a nice day.

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

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

Menu

About Us