Microsoft Office Forums - View Single Post - [Solved] VLOOKUP is dependent up IF function

Thread: [Solved] VLOOKUP is dependent up IF function

View Single Post

Old

09-13-2014, 03:54 PM

dmccrar

dmccrar is offline

dmccrar uses Windows 7 64bit

Windows 7 64bit dmccrar uses Office 2010 64bit

dmccrar uses Office 2010 64bit

Office 2010 64bit

Novice

The original poster

Join Date: Sep 2014

Posts: 1

dmccrar is on a distinguished road

Default

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)

Reply With Quote