Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Turn positive values to negative values if condition is true
Hi,
Can somebody help with a macro doing the following: If cell in column A = "Test" Then turn positive values to negative values in column B+C in corresponding row If cell in column A <"Test" then do nothing If cell in column B or/and cell in column C already has a negative value then do nothing Best regards, Kaj Pedersen |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Turn positive values to negative values if condition is true
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Turn positive values to negative values if condition is true
Hi Claus,
Your suggestion did exactly what I asked for. Thank you for that. However, I have problems to figure out how to change the macro if I want the following: "Test" in column B Values to turn into negative in columns F and H Can you help once more? Thank you. Best regards, Kaj Pedersen |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Turn positive values to negative values if condition is true
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Turn positive values to negative values if condition is true
Hi Claus.
Thank you so much for your help. Everything is now to my full satisfaction. Changing the columns also enabled me to understand how the macro is built, so now I can easily change columns to what I want. Regards, Kaj Pedersen |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Turn positive values to negative values if condition is true
Hi Kaj,
Am Mon, 19 Jun 2017 20:02:22 GMT schrieb : Thank you so much for your help. Everything is now to my full satisfaction. Changing the columns also enabled me to understand how the macro is built, so now I can easily change columns to what I want. you are welcome. I am always glad to help. Regards Claus B. -- Windows10 Office 2016 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
summing only positive or negative values | Excel Worksheet Functions | |||
sum positive and negative values | Excel Programming | |||
how to turn positive to negative values in excel | Excel Worksheet Functions | |||
Formula to make Negative Values Positive & Positive Values Negative? | Excel Discussion (Misc queries) | |||
... Count, <<< Positive Values minus Negative Values >>> ... | Excel Worksheet Functions |