Creating a paragraph text from various cells including a IF statement.

[Magnis89]

I'm currently stuck attempting to create a spreadsheet. What I want is the spreadsheet to generate a paragraph to be read based on the information entered. I can't seem to find something that isn't clunky to deal with and I'd like some help.

I'm going to use the example of returning a product to demonstrate what I need:

I've purchased something at Target. My receipt is valid for returns 14 days from purchase, or up to a year for store credit (Not realistic but I need a secondary date option) and the restocking fee is 15% but were going to use a flat number like $20 to be entered in the cell as 20 formatted as a number not currency


We get something like this:

A | B
Store | Target
Return by | 14 days or 1 year (This is a validated range drop down) selection
14 day date | 22JAN15
1 year date | 08JAN16

this would then generate a paragraph like so:

Your recipet is valid for "Target" and you have "14 days" to return the product until "22JAN15"

OR

Your recipet is valid for "Target" and you have "1 year" to return the product until "08JAN15"

My problem is this. The words inbetween the cell values in the paragraphs need to remain the same regardless of what is chosen, but I can't integrate and if statement to distinguish between both dates. There is a workaround typing out the filler words in the paragraph elsewhere in the spreadsheet and using the formula = Z1 & B2 & Z2 etc etc where Z1 = your reicpet is valid for, z2 = and you have. But then I have to reduce my dates by one cell only either the 14 day physical date or the 1 year physical date, and I want it to be dependant on the selection of B2 and required to enter in values for both B3 and B4.

Is there a way to do this? One nested if formula would prolly do it if someone could show me the correct way to produce the paragraph id be greatful

[mcmahobt]

Would something like this work?

Please Login or Register  to view this content.

Hope this helps!

[Magnis89]

Thank you this did solve the issue I was making it more complex than it had to be!