G
Guest
I want to format a cell to return a number value with a text, depending on
what the value of the number is.
For example if A1 contains the value 4.1%, then I want to use a formula in
B1 to read "4.1% more work days", if the number in A1 is negative, I need B1
to read "4.1 fewer work days". The catch is that I also want to add
additional text, based on an if then statement which I can add with no
problem. Therefore, I cannot simply use a custom number format in the cell
format, and need to use a formula. My challenge is formatting using the
following as a starting point:
=TEXT(A1,"##.##%_more;##.##%_more")&" workdays".
Unfortunately, this formula does not work, and I am not sure what I am
missing. Any help would be much appreciated.
Thanks much
what the value of the number is.
For example if A1 contains the value 4.1%, then I want to use a formula in
B1 to read "4.1% more work days", if the number in A1 is negative, I need B1
to read "4.1 fewer work days". The catch is that I also want to add
additional text, based on an if then statement which I can add with no
problem. Therefore, I cannot simply use a custom number format in the cell
format, and need to use a formula. My challenge is formatting using the
following as a starting point:
=TEXT(A1,"##.##%_more;##.##%_more")&" workdays".
Unfortunately, this formula does not work, and I am not sure what I am
missing. Any help would be much appreciated.
Thanks much