VLOOKUP is dependent up IF function

		Microsoft Office Forums > Microsoft Excel > Excel
VLOOKUP is dependent up IF function

FAQ

Thread Tools

Display Modes

09-13-2014, 03:54 PM

dmccrar

Windows 7 64bit VLOOKUP is dependent up IF function

Office 2010 64bit

Novice

Join Date: Sep 2014

Posts: 1

VLOOKUP is dependent up IF function

I am trying to Get a Letter grade via a VLOOKUP function.
Example:

Total points possible: 75 My test results: 63 Percentage: 84% Letter Grade (B) I get #N/A

Formula for Percentage
=IF(C10="","",IF(C10=>0,+(C10/B10)*100))

Formula for Letter Grade
=VLOOKUP(D10,$b$55:$C$66,1,TRUE)

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Using If and Vlookup Function	jassi.mgg@gmail.com	Excel	5	03-16-2014 01:47 AM
Using vlookup with the IF function	CSzoke	Excel	11	06-01-2013 10:56 PM
Auditing Dependent Cells	WildBill	Excel	2	09-07-2011 10:14 AM
Is this possible using the Vlookup or any other function?	Delson	Excel	4	02-08-2010 01:27 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:01 AM.