How to do IF statement in Microsoft Excel?

[michan]

I have a formula for key in a grade in column A1 that resulting in numeric value in the next column (B1). For example; =IF (A1="A";4) .But how do i make it nested such that when the other than grade A is entered in the same column(A1) will result in other numeric value?e.g. B=3, C=2 and D=1.I was stuck in this problem.

EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com

 

[TaurArian [MS-MVP]]

Repost in the appropriate Excel Newsgroup -
For Web -
http://www.microsoft.com/office/community/en-us/FlyoutOverview.mspx#2

--
====================================
TaurArian [MS-MVP] 2005-2007 - Australia
====================================
How to make a good post: http://www.dts-l.org/goodpost.htm
Backup and data recovery: http://www.acronis.com.sg/
Enhancing file system performance: http://www.diskeeper.com/defrag.asp
Defending your machine: http://defendingyourmachine2.blogspot.com/


<michan> wrote in message |I have a formula for key in a grade in column A1 that resulting in numeric value in the
next column (B1). For example; =IF (A1="A";4) .But how do i make it nested such that when
the other than grade A is entered in the same column(A1) will result in other numeric
value?e.g. B=3, C=2 and D=1.I was stuck in this problem.
|
| EggHeadCafe.com - .NET Developer Portal of Choice
| http://www.eggheadcafe.com