if statement for text

[k_babb]

i am after some help with the if function

i have a column which has numbers and text


so it could have £10

or some have £50cr and the cell is formated as text

i would like to do a if statement so that if column a has a number in it i copies the number if it is text to copy the number lose the cr and make it a negitive value so the £50cr would become -£50

 

[SteveO59L]

will "cr" be the only text ?

 

[k_babb]

yes

 

[SteveO59L]

Something along the lines of

=IF(RIGHT(A1,2)="cr",-LEFT(A1,FIND("c",A1)-1),A1)

 

[k_babb]

thanks so much works great