I'm having trouble with these text if statements. If O155 is > 0 I want it to read "million higher than prior year on". If O155 is < 0 I want it to read "million lower than prior year on". And if O155 is =0 I want it to read "even with prior year on". How can I do this?
="pretax profit of "&TEXT('YTD+newPnL'!F155,"$0.0")&" million for the year to date ended "&TEXT('YTD+newPnL'!O155,"$0.0")&" million higher than prior year on
Bookmarks