Converting the signs and then pasting to a different worksheet with fixed cell

Hello Guys,

Hope its not that tricky for uā€¦
I have some values in a column in the data table, consider the name of the
column as NPV in which I have both negative as well as positive values, now I want to get these values copied to another column in another worksheet (fixed cells) with the inverted signs meaning if I have a value in the column within a data table as -13465.89 so it should be copied to another worksheet as 13466. So round off values as well as sign changed (from negative to positive). Example shown below. Any suggestions on this ā€¦


1 Like

For negative to Positive multiple with -1
and for round off Refer this

Suresh J

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.