Hi

I want to pre-populate a summary based on values

I know i can write
Formula: copy to clipboard
=Gross margin has increased by&" "&"A1"
but i want to be able to write the following

Gross margin has increased by 2% since last year, Purchase price has decreased by £1........

Can i build in a formula to determine whether to write increased or decreased? based on the below figures?

ACTUAL LAST YEAR DIFFERENCE
Gross Margin 5% 3% 2%
Purchase Price £9 £10 -£1

Say the values are in celss c2:d4 i can write
Formula: copy to clipboard
=if(C2>D2,"Increased",If(C2<D2,"Decreased")) 


But how can i incorporate it all so that i can have the sentance i want and include the figures, condition and base?

Base: Gross margin has
Condition: Increased/Decreased
Base: by
Figure: 2%

Any help would be great

Thanks

Dan