Hi
I want to pre-populate a summary based on values
I know i can write
Formula:
=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:
=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
Bookmarks