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!

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!

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!

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!