Change from a negative to a positive
I am working on a buget and need to use the information from one sheet
carried over to another sheet. On the original sheet it is considered a negative number but I need it carried over as a positive number. The formula I am using is: =+'OTHER W'!B19 Thank you! |
Change from a negative to a positive
would:
=-'OTHER W'!B19 work? On 11 Gru, 20:26, Erica wrote: I am working on a buget and need to use the information from one sheet carried over to another sheet. On the original sheet it is considered a negative number but I need it carried over as a positive number. The formula I am using is: =+'OTHER W'!B19 Thank you! |
Change from a negative to a positive
Hi,
Perhaps this would work... 1. On the new sheet put a -1 in a blank cell (you can delete this after) 2. Highlight cell with -1 and control-c to copy 3. highlight rows/columns with data you want to change from neg to pos 4. Click on the Edit Menu and select Paste Special 5. Select "multiply" 6. Click OK Now all the data in the cells you selected should be multiplied by -1 which in effect will change all your neg numbers to pos. 7. You can now delete the -1 from the original cell. Regards, Michael "Erica" wrote: I am working on a buget and need to use the information from one sheet carried over to another sheet. On the original sheet it is considered a negative number but I need it carried over as a positive number. The formula I am using is: =+'OTHER W'!B19 Thank you! |
Change from a negative to a positive
You want the absolute value.
=ABS('Other W'!B19) -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Erica" wrote: I am working on a buget and need to use the information from one sheet carried over to another sheet. On the original sheet it is considered a negative number but I need it carried over as a positive number. The formula I am using is: =+'OTHER W'!B19 Thank you! |
All times are GMT +1. The time now is 07:03 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com