GirishDhruva
Active Member
- Joined
- Mar 26, 2019
- Messages
- 308
Hi every one ,
i am trying to search for negative value in column A and if negative value is found
then the value in next column(i.e, Column C ) should be checked and replaced if the value is 40 then to 50 or if the value is 50 then to 40 .
And even i need to change the negative value to positive and can we round off the decimal value .
Below is the sample workbook.
Regards,
Dhruva.
i am trying to search for negative value in column A and if negative value is found
then the value in next column(i.e, Column C ) should be checked and replaced if the value is 40 then to 50 or if the value is 50 then to 40 .
And even i need to change the negative value to positive and can we round off the decimal value .
Below is the sample workbook.
Dropbox - File Deleted - Simplify your life
www.dropbox.com
Regards,
Dhruva.