You don't format the value using TEXT function in this case. Use format
cells to format. Check the attachment.
Regards,
Sam Mathai Chacko
On Tue, Feb 7, 2012 at 8:49 PM, hilary lomotey wrote:
> Hello Experts,
>
> i have a data, i want the data to read " decrease" when the % change for
> the se
Hello Experts,
i have a data, i want the data to read " decrease" when the % change for
the selected year is -ve eg (7.9%) otherwise to read "positive", i have
used the formula ="This represents a % "&IF(P7<0,"decrease","increase"),
but it doesnt change when the sign changes. kindly assist. thank
