# Excel Forumla help (IF formula)

Solved/Closed
Related:

- Excel Forumla help (IF formula)
- Date formula in excel dd/mm/yyyy - Guide
- Excel grade formula - Guide
- Number to words in excel formula - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Excel free download - Download - Spreadsheets

## 1 response

rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766

Feb 22, 2010 at 06:11 AM

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"))))))

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

Feb 22, 2010 at 04:07 PM