csv hierarchical file with choices & permutations

[H.A Innovations]

Hi,

I am creating a site for a client who's product prices may change every so often and there will be about 300+ products on the site in total.
I am linking the hierarchical csv file to other spreadsheets which hold the calculated prices so that the permutations will change automatically. These products have Choices which also display the price, what I need is for at the end of the choice to also display the permutation price. I have been told by Actinic that this should be possible and to ask on here.

This is this link here to one of the products:
http://www.wheels.uk.com/acatalog/Alessio__ACTION_.html

Thanks
Barry

[Jan]

The way to do this is to add the price to the end of the choice name HTML eg:

red (£45)

obviously this wil not work if you have more than one option eg:

size, colour.

Regards,

Jan

[H.A Innovations]

Thanks for your reply.

Do you know how to link/what to enter into the cell in excel? So that at the end of the choice cell it has the price shown which is linked to another cell.
If your unsure what i mean i could send you the csv file i have.

Thanks
Barry

[NormanRouxel]

Look up CONCATENATE in Excel's Help. That's the function to use.

[H.A Innovations]

Thanks for that Norman, exactly what I needed. The price in the CONCATENATE cell needs to be rounded to 2 decimal place is there a way of doing this?

I have this in my spreadsheet as an example.

Wheel/Tyre Size:
18" 225/40/18

Price:
£85

18" 225/40/18 (£85 inc vat)
the formula to this is:
=CONCATENATE(A2," (£",B2," inc vat)")

Thanks
Barry

[NormanRouxel]

cell needs to be rounded to 2 decimal place is there a way of doing this

I had no idea. However a quick look in the Help took me to the DOLLAR function. Didn't you try the Help?

[webyourbusiness]

Thanks for that Norman, exactly what I needed. The price in the CONCATENATE cell needs to be rounded to 2 decimal place is there a way of doing this?

I have this in my spreadsheet as an example.

Wheel/Tyre Size:
18" 225/40/18

Price:
£85

18" 225/40/18 (£85 inc vat)
the formula to this is:
=CONCATENATE(A2," (£",B2," inc vat)")

Thanks
Barry

You need to use TEXT() to format numbers...

What you are trying to achieve is done using this formula:
=A2&" "&TEXT(B2,"£0.00")&" inc vat"

I prefer to use A:A and B:B if the result is in A:A and the field I'm working on is in the same row - say both are in row 2:2... I have no evidence, but I think the row references make for smaller spreadsheets.

=A:A&" "&TEXT(B:B,"£0.00")&" inc vat"

What I'd do if I was going to use this sheet time and time again, is name the columns and put a number of commonly used pieces of text on a worksheet 0- with names, so that my ending formular might look like:

=short_desc&spc&TEXT(price,"£0.00")&inc_vat

but that's how *I* would do it...

regards

Greg