Hello Sir,

i am just confuse to convert the number to negative number using with specific text

in ColumnA i give some Text like Shortage, Damage

When i enter the number in ColumnB then the Number must be negative when the Specific Text is not Mention in the ColumnA then the ColumnB Number is normal mode

With Regards

Patnaik