"Better/Worse" text based on a postive/negative value

Hello. How could I modify the following formula to return "million WORSE" when the value is negative. Right now it's returning "million BETTER" regardless if the value is positive or negative. Thanks.


="Home Warranty reported a "&TEXT(H196,"$0.0")&" million pre-tax profit for "&TEXT(newPnLdate,"Mmmm yyyy")&" which is "&IF(ROUND(Q196,1)=0,"flat to last ",TEXT(Q196,"$0.0")&" million better than last ")&TEXT(newPnLdate,"Mmmm")&" and "&TEXT(L196,"$0.0")&" million better than the "&whichfcstnewPnL&" forecast. "

No, I want to do it, using an if statment, so I don't have to manually change the better worse. Right now if it's 0 it returns "flat to last", but if it's not 0, it returns "better". I want to add another If statement in there but I don't know how to. HELP!!!!

Perfect, except can you add the if statement for the last part too? &" and "&TEXT(L196,"$0.0")&" million better than the "&whichfcstnewPnL&" forecast. ") This part compares to prior year but it's the same concept. Thanks