Add to previous price

[Kmsulliv]

I am working on a database for a store. For this store if a customer buys a shirt it is 14.00, If the customer wishes to have the shirt in color it is an additional 2.00, if they want in with long sleeves it is additional 3.00. I have all the information correct, I am just wondering what formula I use in the cells for color, sleeve, etc. to make this work? Thanks.

[teylyn]

Hi,

there are several ways to solve this. It depends what input you expect in the columns for color and sleeve. If the user enters a Y or yes or something like that in column C for colour, then you could add another column next to it with a formula like

=IF(C2="Y",2,0)

and the same for sleeves. Then you just add up the columns with numbers.

Or if you don't want extra columns, you could use a formula in your total column like below

Column C has "y" for color, column D has "y" for sleeve, column B has standard price

=B2+IF(C2="y",2,0)+IF(D2="y",3,0)

Hope that helps

Teylyn

[JBeaucaire]

You could also employ the suggestion above all in the one price cell, just eliminate the B column price and replace B2 with the price in the formula.

Please Login or Register  to view this content.