Hi There

I was wondering if there is a way to have a currency number be positive or negative based on a another cell?

for example

sumif = "expenses" then the number displays as negitive (-1000)

sumif = "income then number would display as positive (1000) with out the nimus?