text; percentage; format

  1. Smokeyham

    Format Negative Percentage - Text Function?

    I have the following formula in a cell: ="% Change in Services"&" & "&"and Supplies "&(TEXT((V319-T319)/T319,"0.00%")) This works fine, but I would like to have this show any negative percentages with brackets, and in red font, as opposed to "-7.35%" which is how this currently shows up...

Some videos you may like

This Week's Hot Topics

Top