Hello,
The following formula that I am using works somewhat fine:
=IFERROR(IF(N12=0,"",N12/$N$16),"")
However, some numbers inside the N column are negative numbers but the report I have does not show the negative numbers in parenthesis or with a negative sign before it. Instead, the report shows negative numbers like this <2,345> . Therefore when I use the formula above it comes out blank in cases where there is supposed to be a negative number. Is there a way to change the less than < and greater than> symbols to a parenthesis (2,345) or negative sign -2,345 ?
Thanks.
Bookmarks