Hi everyone, first of all sorry for my english. I am here because i have a problem that need to be solved because is for work and i dont´t know how to make it happen.
I am developing a worksheet that have several sheets that contain a table.
All the 4th sheets have the same table, with the same titles but different information and rows.
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD="align: center"]COLUMN A[/TD]
[TD="align: center"]COLUMN B[/TD]
[/TR]
[TR]
[TD="align: center"]TITLE X[/TD]
[TD="align: center"]TITLE Y[/TD]
[/TR]
[TR]
[TD]Random[/TD]
[TD]- Numbers[/TD]
[/TR]
[TR]
[TD]Random2[/TD]
[TD]-+ Numbers[/TD]
[/TR]
</tbody>[/TABLE]
I need all the numbers input in "TITLE Y" to be NEGATIVE ONLY if "TITLE X" is Random. If "TITLE X" is Random 2 then positive or negative.
In "TITLE X" i have 9 different ones that only allowes negative numbers and 4 all type of decimal numbers.
I wish i don´t make a mess and if i do, please tell me.
Thanks,
Damian.-
I am developing a worksheet that have several sheets that contain a table.
All the 4th sheets have the same table, with the same titles but different information and rows.
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD="align: center"]COLUMN A[/TD]
[TD="align: center"]COLUMN B[/TD]
[/TR]
[TR]
[TD="align: center"]TITLE X[/TD]
[TD="align: center"]TITLE Y[/TD]
[/TR]
[TR]
[TD]Random[/TD]
[TD]- Numbers[/TD]
[/TR]
[TR]
[TD]Random2[/TD]
[TD]-+ Numbers[/TD]
[/TR]
</tbody>[/TABLE]
I need all the numbers input in "TITLE Y" to be NEGATIVE ONLY if "TITLE X" is Random. If "TITLE X" is Random 2 then positive or negative.
In "TITLE X" i have 9 different ones that only allowes negative numbers and 4 all type of decimal numbers.
I wish i don´t make a mess and if i do, please tell me.
Thanks,
Damian.-