Logical Formula with Text

[howard]

I have the the following formula below

 =IF(B25-C25>0,"The the profit has increased by "&TEXT(B25-C25,"R#0,##0")&""),IF(B25-C25<0,"Thn the profit has decreased by "&TEXT(B25-C25,"R#0,##0")&"")

I get #value !


If the result of B25-c25 > 0 , then it must show Then the profit has increased by b25-C25, otherwise if B25-C25 < 0 show "the profit has decreased by B25-C25


It would be appreciated if someone could assist me

 

[Marcelo Branco]

Try

=IF(B25-C25>0,"Then the profit has increased by "&TEXT(B25-C25,"R#0,##0"),IF(B25-C25<0,"Then the profit has decreased by "&TEXT(B25-C25,"R#0,##0")))

M.

 

[howard]

thanks for the help, much appreciated

 

[Marcelo Branco]

You are welcome. Thanks for the feedback.

M.