Conditional Formatting Formula + Concatenate

[thankyouvince]

Hi Good day!

I need some help regarding this case. To make it fast, IF i input in A1 "-100", then I want to return in the same cell (AED 100) but if I input "100" (without negative) it will return AED 100 (no parenthesis.

This goes to any number not just 100. The key factor is that negative sign. Thanks for the help!

 

[Rick Rothstein]

I need some help regarding this case. To make it fast, IF i input in A1 "-100", then I want to return in the same cell (AED 100) but if I input "100" (without negative) it will return AED 100 (no parenthesis.

This goes to any number not just 100. The key factor is that negative sign. Thanks for the help!

Assuming you are dealing with whole numbers only (as per your example), you do not need to use Conditional Formattint... you can do what you want with a normal Custom Format for the cell, just use this type pattern...

"AED" 0;("AED" 0)