Is it possible to write an IF formula that would add currency to a cell? (currency that can be summed, not just the appearance). I've tried but all I can get it to do is put the data, not the $$.
Current formula is:
I have also tried: