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...