Simple IF

[hsandeep]

I know its simplest..still I need since I made mistake

Input Cell: B2 which can be EITHER of “d2” or “d3” or “d4” or “d5”. That’s All

Output Cell: D2:
IF B2=”d2” THEN D2=”k3”
IF B2=”d3” THEN D2=”k4”
IF B2=”d4” THEN D2=”k5”
IF B2=”d5” THEN D2=”k6”

How to accomplish?
I am using Excel 2007

 

[hsandeep]

How about
=INDIRECT("F"&RIGHT($B$2)+ROW(A1))

NO it is giving wrong answer as 0. It should be giving 'formula' =F3 in cell G2 for B2 containing text 'd2'

 

[Fluff]

NO it is NOT giving wrong answer.

Book1
	B	E	F	G
2	d2		abc2	abc3
3			abc3	abc4
4			abc4	abc5
5			abc5	abc6
6			abc6	abc7
7			abc7	abc8
8			abc8	abc9
9			abc9	abc10
10			abc10	abc11
11			abc11	abc12
12			abc12
13			abc13
14			abc14
15			abc15
16			abc16
work

Cell Formulas
Range	Formula
G2	=INDIRECT("F"&RIGHT($B$2)+ROW(A1))

 

[hsandeep]

NO it is NOT giving wrong answer.

You are CORRECT. I was WRONG. IT WORKS & as desired. Thanks Fluff

 

[Fluff]

You're welcome & please stop SHOUTING at people (using uppercase letters) it's considered rude.

 

[hsandeep]

Another way

A different situation for D2

D2=1 if B2>0
D2=0 if B2<0
D2=null if B2=zero 0 or null

How to accomplish please?

 

[Fluff]

As this is a totally different question, please start a new thread.
Thanks