retail price averaging and rounding

[paperlion]

I have inventory product data that I want to modify prices for.

The actual data is cost-related. I want to apply percentages to it to determine both the discounted selling price and the 'suggested' retail price.

But I also want to round or average the results to the tenths place and average those results to either .95 or .15 for the cents units (by first testing for .50 and splitting with an IF statement?).

...and would be best if from a remote cell. Anyone? Thanks.

[Json]

I have inventory product data that I want to modify prices for.

The actual data is cost-related. I want to apply percentages to it to determine both the discounted selling price and the 'suggested' retail price.

But I also want to round or average the results to the tenths place and average those results to either .95 or .15 for the cents units (by first testing for .50 and splitting with an IF statement?).

...and would be best if from a remote cell. Anyone? Thanks.

Price in Cell A1 = 3.45

Please Login or Register  to view this content.

=> 4.05, add margin of 50%

Please Login or Register  to view this content.

=> 3.11, discounts 10%

Please Login or Register  to view this content.

=> 3.15

Round or average the results to the tenths place and average those results to either .95 or .15 for the cents units (by first testing for .50 and splitting with an IF statement?).

I think that is the last bit but I am a little confused by the word average

[paperlion]

Greaaaaat! Fantastic.