Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formating individual cells
Hi, I am trying to format individual cells to give me a negative answer, can
this be done. Example: 2 + 2 = 4 I need to try and get the answer to become 2 + 2 = -4 any help would be appreciated thanks in anticipation! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formating individual cells
Assuming the two cells are in A1 and B1
enter in C1 =-A1-B1 Greetings from New Zealand Bill K "piper" wrote in message ... Hi, I am trying to format individual cells to give me a negative answer, can this be done. Example: 2 + 2 = 4 I need to try and get the answer to become 2 + 2 = -4 any help would be appreciated thanks in anticipation! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formating individual cells
No such luck but thanks what I am trying to achieve is for example in cell
'O'11 I need to place the formula to produce the answer. In cell 'O'6 the the number I want to multipy the number in cell 'P'10 with this produces an negative answer and I need to try and get it to produce a positive answer by somehow getting rid of the minus sign in the answer cell O11. Sum I am doing is 0.36 x -23.5 = -8.46 need to tyry and get it to become 8.46. ?. "Bill Kuunders" wrote: Assuming the two cells are in A1 and B1 enter in C1 =-A1-B1 Greetings from New Zealand Bill K "piper" wrote in message ... Hi, I am trying to format individual cells to give me a negative answer, can this be done. Example: 2 + 2 = 4 I need to try and get the answer to become 2 + 2 = -4 any help would be appreciated thanks in anticipation! |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formating individual cells
=ABS(0.36*-23.5)
=ABS(O6*P10) Gord Dibben MS Excel MVP On Thu, 23 Nov 2006 13:16:02 -0800, piper wrote: No such luck but thanks what I am trying to achieve is for example in cell 'O'11 I need to place the formula to produce the answer. In cell 'O'6 the the number I want to multipy the number in cell 'P'10 with this produces an negative answer and I need to try and get it to produce a positive answer by somehow getting rid of the minus sign in the answer cell O11. Sum I am doing is 0.36 x -23.5 = -8.46 need to tyry and get it to become 8.46. ?. "Bill Kuunders" wrote: Assuming the two cells are in A1 and B1 enter in C1 =-A1-B1 Greetings from New Zealand Bill K "piper" wrote in message ... Hi, I am trying to format individual cells to give me a negative answer, can this be done. Example: 2 + 2 = 4 I need to try and get the answer to become 2 + 2 = -4 any help would be appreciated thanks in anticipation! |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formating individual cells
Try this:
(A1+B1)*-1 "piper" wrote: Hi, I am trying to format individual cells to give me a negative answer, can this be done. Example: 2 + 2 = 4 I need to try and get the answer to become 2 + 2 = -4 any help would be appreciated thanks in anticipation! |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formating individual cells
Cheers Sandy
Frae Hammy in the Scottish Borders! "Sandy Mann" wrote: Try: =ABS(O6*P10) -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings with @tiscali.co.uk "piper" wrote in message ... No such luck but thanks what I am trying to achieve is for example in cell 'O'11 I need to place the formula to produce the answer. In cell 'O'6 the the number I want to multipy the number in cell 'P'10 with this produces an negative answer and I need to try and get it to produce a positive answer by somehow getting rid of the minus sign in the answer cell O11. Sum I am doing is 0.36 x -23.5 = -8.46 need to tyry and get it to become 8.46. ?. "Bill Kuunders" wrote: Assuming the two cells are in A1 and B1 enter in C1 =-A1-B1 Greetings from New Zealand Bill K "piper" wrote in message ... Hi, I am trying to format individual cells to give me a negative answer, can this be done. Example: 2 + 2 = 4 I need to try and get the answer to become 2 + 2 = -4 any help would be appreciated thanks in anticipation! |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formating individual cells
Thanks Gord
that has solved it "Gord Dibben" wrote: =ABS(0.36*-23.5) =ABS(O6*P10) Gord Dibben MS Excel MVP On Thu, 23 Nov 2006 13:16:02 -0800, piper wrote: No such luck but thanks what I am trying to achieve is for example in cell 'O'11 I need to place the formula to produce the answer. In cell 'O'6 the the number I want to multipy the number in cell 'P'10 with this produces an negative answer and I need to try and get it to produce a positive answer by somehow getting rid of the minus sign in the answer cell O11. Sum I am doing is 0.36 x -23.5 = -8.46 need to tyry and get it to become 8.46. ?. "Bill Kuunders" wrote: Assuming the two cells are in A1 and B1 enter in C1 =-A1-B1 Greetings from New Zealand Bill K "piper" wrote in message ... Hi, I am trying to format individual cells to give me a negative answer, can this be done. Example: 2 + 2 = 4 I need to try and get the answer to become 2 + 2 = -4 any help would be appreciated thanks in anticipation! |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formating individual cells
what does ABS do/mean? and if I wanted to do the opposite make a positive a
negative can you tel me what needs to be done? Cheers "Sandy Mann" wrote: Try: =ABS(O6*P10) -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings with @tiscali.co.uk "piper" wrote in message ... No such luck but thanks what I am trying to achieve is for example in cell 'O'11 I need to place the formula to produce the answer. In cell 'O'6 the the number I want to multipy the number in cell 'P'10 with this produces an negative answer and I need to try and get it to produce a positive answer by somehow getting rid of the minus sign in the answer cell O11. Sum I am doing is 0.36 x -23.5 = -8.46 need to tyry and get it to become 8.46. ?. "Bill Kuunders" wrote: Assuming the two cells are in A1 and B1 enter in C1 =-A1-B1 Greetings from New Zealand Bill K "piper" wrote in message ... Hi, I am trying to format individual cells to give me a negative answer, can this be done. Example: 2 + 2 = 4 I need to try and get the answer to become 2 + 2 = -4 any help would be appreciated thanks in anticipation! |
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formating individual cells
ABS( ) gives you the absolute value, i.e. the magnitude without the
sign. If you want to force a value to be negative, you can multiply this by -1, i.e.: =-1*ABS(whatever) Hope this helps. Pete piper wrote: what does ABS do/mean? and if I wanted to do the opposite make a positive a negative can you tel me what needs to be done? Cheers "Sandy Mann" wrote: Try: =ABS(O6*P10) -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings with @tiscali.co.uk "piper" wrote in message ... No such luck but thanks what I am trying to achieve is for example in cell 'O'11 I need to place the formula to produce the answer. In cell 'O'6 the the number I want to multipy the number in cell 'P'10 with this produces an negative answer and I need to try and get it to produce a positive answer by somehow getting rid of the minus sign in the answer cell O11. Sum I am doing is 0.36 x -23.5 = -8.46 need to tyry and get it to become 8.46. ?. "Bill Kuunders" wrote: Assuming the two cells are in A1 and B1 enter in C1 =-A1-B1 Greetings from New Zealand Bill K "piper" wrote in message ... Hi, I am trying to format individual cells to give me a negative answer, can this be done. Example: 2 + 2 = 4 I need to try and get the answer to become 2 + 2 = -4 any help would be appreciated thanks in anticipation! |
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formating individual cells
ABS gives you the absolute value of a number, i.e. the number without its
sign. As with virtually any of Excel's worksheet functions you can find information in Excel's help. If you want merely to reverse the sign of a calculation (positive to negative, or nehative to positive), just use a minus sign =-O6*P10 -- David Biddulph "piper" wrote in message ... what does ABS do/mean? and if I wanted to do the opposite make a positive a negative can you tel me what needs to be done? Cheers "Sandy Mann" wrote: Try: =ABS(O6*P10) -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings with @tiscali.co.uk "piper" wrote in message ... No such luck but thanks what I am trying to achieve is for example in cell 'O'11 I need to place the formula to produce the answer. In cell 'O'6 the the number I want to multipy the number in cell 'P'10 with this produces an negative answer and I need to try and get it to produce a positive answer by somehow getting rid of the minus sign in the answer cell O11. Sum I am doing is 0.36 x -23.5 = -8.46 need to tyry and get it to become 8.46. ?. "Bill Kuunders" wrote: Assuming the two cells are in A1 and B1 enter in C1 =-A1-B1 Greetings from New Zealand Bill K "piper" wrote in message ... Hi, I am trying to format individual cells to give me a negative answer, can this be done. Example: 2 + 2 = 4 I need to try and get the answer to become 2 + 2 = -4 any help would be appreciated thanks in anticipation! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I protect individual cells in Excel and not whole sheet? | Excel Discussion (Misc queries) | |||
conditional formating / linked cells? | Excel Discussion (Misc queries) | |||
Formating Worksheet Cells | Excel Discussion (Misc queries) | |||
Sizing individual Cells | Excel Worksheet Functions | |||
how do you create drop down menus for individual cells in excel? | Excel Worksheet Functions |