Return a value based on another cell. IF statement?

[MadHatsJess]

Hi,

I have one column with something like the below;

A1

£100 deal
£200 deal
£300 deal

In B2 I need to return the value of the cell (depending on what is in A1)

Would I use an IF statement? (Cant get it to work)

IF A1 = £100 deal then return £100
IF A1 = £200 deal then return £200
IF A1 = £300 deal then return £300

Thanks in advance

 

[oldbrewer]

=if(a1="£100 deal",£100,if(a1="£200 deal",£200,£300))

 

[Raymond_India]

This is just a work around. Ok ?
In Cell B2 just type =LEFT(A1,LEN(A1-4)
What you get in cell B2 would be just the value £whatever.
There is no limitation of having to enter just £100 deal or £200 deal or £300 deal here. You can easily enter say £5142 deal and cell B2 would just say £5142
Helps ??

 

[jtakw]

Hi,

Try these:

Book1
	A	B	C	D
1	£100 deal	£100	100	£100
2	£200 deal	£200	200	£200
3	£300 deal	£300	300	£300
4	£3 deal	£3	3	£3
5	£3000000 deal	£3000000	3000000	£3,000,000
6	£3000 deal	£3000	3000	£3,000
7		Result is Text	Result as Real Number	Result as Real Number
8				Formatted as currency £
Sheet105

Cell Formulas
Range	Formula
B1	=SUBSTITUTE(A1,"deal","")
C1	=MID(SUBSTITUTE(A1,"deal",""),2,15)+0
D1	=MID(SUBSTITUTE(A1,"deal",""),2,15)+0