I need to drof the DR and CR which is not problem, but I also need to change
the number that end in DR to a negative number.

I've tried using the if function and the right function to check for the
letters DR
like this but it doesn't work.

=IF(RIGHT(a1,2)=dr,a1*-1,a1)

I need to check for text characters DR and i can't figure out how to do it
with the if function. I may need to use a macro, I'm not sure.
--
Billy Rogers

Dallas,TX

Currently Using SQL Server 2000, Office 2000 and Office 2003

> =IF(RIGHT(a1,2)=dr,a1*-1,a1)

TRY
=IF(RIGHT(A1,2)="DR",MID(A1,1,(LEN(A1)-2))*-1,MID(A1,1,LEN(A1)-2)*1)
--
Mike Q.


"BillyRogers" wrote:

> I need to drof the DR and CR which is not problem, but I also need to change
> the number that end in DR to a negative number.
>
> I've tried using the if function and the right function to check for the
> letters DR
> like this but it doesn't work.
>
> =IF(RIGHT(a1,2)=dr,a1*-1,a1)
>
> I need to check for text characters DR and i can't figure out how to do it
> with the if function. I may need to use a macro, I'm not sure.
> --
> Billy Rogers
>
> Dallas,TX
>
> Currently Using SQL Server 2000, Office 2000 and Office 2003

"dr"

--
Don Guillett
SalesAid Software
(E-Mail Removed)
"BillyRogers" <(E-Mail Removed)> wrote in message
news:60558C81-D4F4-41C5-84A9-(E-Mail Removed)...
>I need to drof the DR and CR which is not problem, but I also need to
>change
> the number that end in DR to a negative number.
>
> I've tried using the if function and the right function to check for the
> letters DR
> like this but it doesn't work.
>
> =IF(RIGHT(a1,2)=dr,a1*-1,a1)
>
> I need to check for text characters DR and i can't figure out how to do it
> with the if function. I may need to use a macro, I'm not sure.
> --
> Billy Rogers
>
> Dallas,TX
>
> Currently Using SQL Server 2000, Office 2000 and Office 2003

=LEFT(B7,FIND("r",B7)-2)*IF(RIGHT(B7,2)="dr",-1,1)

--
Don Guillett
SalesAid Software
(E-Mail Removed)
"Don Guillett" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> "dr"
>
> --
> Don Guillett
> SalesAid Software
> (E-Mail Removed)
> "BillyRogers" <(E-Mail Removed)> wrote in message
> news:60558C81-D4F4-41C5-84A9-(E-Mail Removed)...
>>I need to drof the DR and CR which is not problem, but I also need to
>>change
>> the number that end in DR to a negative number.
>>
>> I've tried using the if function and the right function to check for the
>> letters DR
>> like this but it doesn't work.
>>
>> =IF(RIGHT(a1,2)=dr,a1*-1,a1)
>>
>> I need to check for text characters DR and i can't figure out how to do
>> it
>> with the if function. I may need to use a macro, I'm not sure.
>> --
>> Billy Rogers
>>
>> Dallas,TX
>>
>> Currently Using SQL Server 2000, Office 2000 and Office 2003
>
>