Excel Forumla help (IF formula) [Solved/Closed]

Question

Excel Forumla help (IF formula) [Solved/Closed]

Report

pleasehelp1101 - Feb 22, 2010 at 01:54 AM
pleasehelp1101 - Feb 22, 2010 at 04:07 PM

Hello,

I need some help, I just can't figure the IF formula out. On my Excel 2007 spreadsheet, I am trying to figure out if I put the letter grade of a B in one column and then in another separate column it automatically produces a 3. Also, I need each column to be flexible so that if I get an A in on course, then the corresponding column next to it will produce a 4 in it. I am trying to make a spreadsheet to keep track of my ongoing grades and I am stuck on this step. Thanks for the help in advance.

Excel Forumla help (IF formula)
Excel can't see formula bar - How-To - Excel
Excel at symbol in formula ✓ - Forum - Excel
Excel - How to display formulas in spreadsheet? - How-To - Excel
Excel debit credit balance formula - How-To - Excel
Excel me grade ka formula - How-To - Excel

1 reply

Ask a question

rizvisa1 · Accepted Answer · 2010-02-22T06:11:02-0500

Answer 1 / 1

rizvisa1

Posts: 4476
Registration date: Thursday January 28, 2010
Status: Contributor
Last seen: August 2, 2020

767
Feb 22, 2010 at 06:11 AM

in that column where you wants the digits to appear, you need to use this sort of formula

=IF(A1="", "", IF(A1="A", 4, IF(A1="B", 3, IF(A1="C", 2, IF(A1="D", 1, IF(A1="F",0,"Invalid Entry"))))))

Report

pleasehelp1101
Feb 22, 2010 at 04:07 PM

Thank you so much, you helped so much! It's all done now!

Excel Forumla help (IF formula) [Solved/Closed]

1 reply

Your reply

Subscribe To Our Newsletter!