Forum Discussion
Solved
Formatting Negative Numbers
I am using the formula =IF(A1>C1, A1-C1, C1-A1). A1-C1 returns a negative number. How can I show the negative number in parentheses. Thank you.
Brian3302 I'd say you just enter =C1-A1 in B1. That will return 15 in the first example and -15 in the second.
Thank you for your response. I now believe that I did not adequately describe this issue. There are three columns: A1:A300, B1:B300 and C1:C300. I entered the starting number in A1 and entered the ending number in C1. I entered the formula in B1. When a number was entered in A1 and C1, the correct number was returned in B1. However, it did not indicate if the number was positive or negative and I tried to get the negative number in parentheses but was unable to do so.
