Multiplying by -1

[tinge89]

Hi all,

I have several cells containing numbers, and also either DB or CR depending on whether the amount is positive or negative.

Eg. 100,000 DB would be -100,000
100,000 CR would be +100,000

I need to work out a way to convert the cells from the DB/CR format to a number format so that they can be used in formulas.

Does anyone have an idea as to how i might go about doing this?

Thanks

[Pete_UK]

Try this:

=IF(RIGHT(A1,2)="DB",-1,1)*TRIM(LEFT(A1,LEN(A1)-2))

with your entry in A1.

Hope this helps.

Pete

[Ghozi Alkatiri]

try it
=LEFT(A1,FIND(" ",A1))*IF(RIGHT(A1,2)="DB",-1,1)

[tinge89]

Thanks Pete, that worked perfectly