Originally Posted by
maggie88ca
Hi all,
New user here and I hope ........ percentages?
A B
1 Total amount invested $100
2 Current total value $95
3 Profit/Loss -5
4 Percent -5%
I want to display ..........as either a positive or negative percent?
I hope that was clear.
Thanks,
G'Day and
Welcome to the forum
Formula for cell A3 is
Formula for cell A4
You may have to format the cell as a percentage or the decimal point will be in the wrong spot. If do not want the % sign showing see the following code
Cheers
Al
Bookmarks