Help with formula
Hi How do I creat a formula by switching the operation sign, for example: From Negative Ten (-10) to positive of 10 Vice versa From Positive of 10 to Negative (-10) Thank you Sothea |
Help with formula
For the negative number to be changed to a positive number, you can do
ABS(-10) which returns 10. I'm not aware of a function which returns the negative equivalent of a positive number. Perhaps =X-2X. Exmple: =10-2(10) = -10. Dave -- Brevity is the soul of wit. "Soth" wrote: Hi How do I creat a formula by switching the operation sign, for example: From Negative Ten (-10) to positive of 10 Vice versa From Positive of 10 to Negative (-10) Thank you Sothea |
Help with formula
is it as simple as newx = -1* oldx, or newx = 0-oldx?
or have I misunderstood? "Soth" wrote in message ... Hi How do I creat a formula by switching the operation sign, for example: From Negative Ten (-10) to positive of 10 Vice versa From Positive of 10 to Negative (-10) Thank you Sothea |
Help with formula
=-A1
will return the value of A1 with its sign changed (Grade 9 algebra!) best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Soth" wrote in message ... Hi How do I creat a formula by switching the operation sign, for example: From Negative Ten (-10) to positive of 10 Vice versa From Positive of 10 to Negative (-10) Thank you Sothea |
Help with formula
Yes it's that simple.
-- Brevity is the soul of wit. "David Cox" wrote: is it as simple as newx = -1* oldx, or newx = 0-oldx? or have I misunderstood? "Soth" wrote in message ... Hi How do I creat a formula by switching the operation sign, for example: From Negative Ten (-10) to positive of 10 Vice versa From Positive of 10 to Negative (-10) Thank you Sothea |
Help with formula
Dave,
Great ! ABS(-10) is what i'm looking for. But how I do change positive 10 to Negative 10? I have a list such as below, like to change to operation sign: -10 10 -20 30 -50 Thanks Soth "Dave F" wrote: For the negative number to be changed to a positive number, you can do ABS(-10) which returns 10. I'm not aware of a function which returns the negative equivalent of a positive number. Perhaps =X-2X. Exmple: =10-2(10) = -10. Dave -- Brevity is the soul of wit. "Soth" wrote: Hi How do I creat a formula by switching the operation sign, for example: From Negative Ten (-10) to positive of 10 Vice versa From Positive of 10 to Negative (-10) Thank you Sothea |
Help with formula
Hi Soth
multiply the values with -1 (minus one) say for 10 in A1 multiply it as =A1*(-1) for -10 in A2 multiply as =A2*(-1) Hope this works for you. Thanks, Shail Soth wrote: Dave, Great ! ABS(-10) is what i'm looking for. But how I do change positive 10 to Negative 10? I have a list such as below, like to change to operation sign: -10 10 -20 30 -50 Thanks Soth "Dave F" wrote: For the negative number to be changed to a positive number, you can do ABS(-10) which returns 10. I'm not aware of a function which returns the negative equivalent of a positive number. Perhaps =X-2X. Exmple: =10-2(10) = -10. Dave -- Brevity is the soul of wit. "Soth" wrote: Hi How do I creat a formula by switching the operation sign, for example: From Negative Ten (-10) to positive of 10 Vice versa From Positive of 10 to Negative (-10) Thank you Sothea |
Help with formula
You're the best ! Thank you Shail. Just what i'm lookin for. "shail" wrote: Hi Soth multiply the values with -1 (minus one) say for 10 in A1 multiply it as =A1*(-1) for -10 in A2 multiply as =A2*(-1) Hope this works for you. Thanks, Shail Soth wrote: Dave, Great ! ABS(-10) is what i'm looking for. But how I do change positive 10 to Negative 10? I have a list such as below, like to change to operation sign: -10 10 -20 30 -50 Thanks Soth "Dave F" wrote: For the negative number to be changed to a positive number, you can do ABS(-10) which returns 10. I'm not aware of a function which returns the negative equivalent of a positive number. Perhaps =X-2X. Exmple: =10-2(10) = -10. Dave -- Brevity is the soul of wit. "Soth" wrote: Hi How do I creat a formula by switching the operation sign, for example: From Negative Ten (-10) to positive of 10 Vice versa From Positive of 10 to Negative (-10) Thank you Sothea |
Help with formula
Enter -1 in an empty cell.
Copy that cell and select your range of data. Editpaste specialmultiply to the selected cells. Gord Dibben MS Excel MVP On Tue, 5 Sep 2006 11:39:02 -0700, Soth wrote: Dave, Great ! ABS(-10) is what i'm looking for. But how I do change positive 10 to Negative 10? I have a list such as below, like to change to operation sign: -10 10 -20 30 -50 Thanks Soth "Dave F" wrote: For the negative number to be changed to a positive number, you can do ABS(-10) which returns 10. I'm not aware of a function which returns the negative equivalent of a positive number. Perhaps =X-2X. Exmple: =10-2(10) = -10. Dave -- Brevity is the soul of wit. "Soth" wrote: Hi How do I creat a formula by switching the operation sign, for example: From Negative Ten (-10) to positive of 10 Vice versa From Positive of 10 to Negative (-10) Thank you Sothea |
Help with formula
Hi Soth
Thanks for the feedback. Shail Soth wrote: You're the best ! Thank you Shail. Just what i'm lookin for. "shail" wrote: Hi Soth multiply the values with -1 (minus one) say for 10 in A1 multiply it as =A1*(-1) for -10 in A2 multiply as =A2*(-1) Hope this works for you. Thanks, Shail Soth wrote: Dave, Great ! ABS(-10) is what i'm looking for. But how I do change positive 10 to Negative 10? I have a list such as below, like to change to operation sign: -10 10 -20 30 -50 Thanks Soth "Dave F" wrote: For the negative number to be changed to a positive number, you can do ABS(-10) which returns 10. I'm not aware of a function which returns the negative equivalent of a positive number. Perhaps =X-2X. Exmple: =10-2(10) = -10. Dave -- Brevity is the soul of wit. "Soth" wrote: Hi How do I creat a formula by switching the operation sign, for example: From Negative Ten (-10) to positive of 10 Vice versa From Positive of 10 to Negative (-10) Thank you Sothea |
All times are GMT +1. The time now is 06:28 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com