Hello there
I have the following part embedded in a formula
if the value is negative, how can I show brackets and red?
This is my formula
=CHOOSE($E$4,TEXT(T9,"€0.00"),TEXT(AH9,"#,#"),TEXT(AV9,"##%"),TEXT(BJ9,"##%"))
Hello there
I have the following part embedded in a formula
if the value is negative, how can I show brackets and red?
This is my formula
=CHOOSE($E$4,TEXT(T9,"€0.00"),TEXT(AH9,"#,#"),TEXT(AV9,"##%"),TEXT(BJ9,"##%"))
Last edited by jw01; 09-18-2014 at 10:13 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks