Forum Discussion
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.
Brian3302 I'd say you just enter =C1-A1 in B1. That will return 15 in the first example and -15 in the second.
