Price sheets

[Benwest33]

I have pricing I send out on monthly basis to distributors. First column is the base price which could be $22.98, $19.01, etc. next column is the base price +$1.50, last column is base price -$1.50. How do I get the last digit in pricing to always be a 6, I.E. base price = $22.48 + first column =$22.24+$1.50 is $23.74 (4 needs to be a 6). Is this possible?

 

[StuLux]

Sorry but your question doesn't make sense as you contradict yourself i.e. Column A is Base Price (say $22.48), Column B is Base Price + $1.50 (i.e. $22.48 + $1.50 = $23.98) and Column C is Base Price - $1.50 (i.e. $22.48 -$1.50 = $20.98) - not sure where you get $22.24/$23.74 from.

You are then saying that Column C must always end with a 6 therefore your rules about deducting $1.50 don't always apply as the amount you are deductign must vary to make the last digit 6.

Is it possible for you to post some data/examples to clarify?

 

[DataBlake]

try
=MID(A2,1,LEN(A2)-1)&"6"

 

[Benwest33]

Sorry but your question doesn't make sense as you contradict yourself i.e. Column A is Base Price (say $22.48), Column B is Base Price + $1.50 (i.e. $22.48 + $1.50 = $23.98) and Column C is Base Price - $1.50 (i.e. $22.48 -$1.50 = $20.98) - not sure where you get $22.24/$23.74 from.

You are then saying that Column C must always end with a 6 therefore your rules about deducting $1.50 don't always apply as the amount you are deductign must vary to make the last digit 6.

Is it possible for you to post some data/examples to clarify?

column F has about 50 rows with various prices, column g +1.50, column h -1.50.

I have 2 other reps that are each designated by their penny digit, sales rep X is 6, sales rep y is 4. When a sale comes into our system this penny digit helps decide whose sale it is. Every month when our price grids change, I cut and paste column F from master price sheet to price sheet attached here and column g and h auto populate. Would like to distribute this to my sales reps where column g and h numbers all end the exact penny digit of either 6 or 4.

 

[Benwest33]

try
=MID(A2,1,LEN(A2)-1)&"6"

That’s the right formula but I need it to in column g add 1.50 and end with 6, column H deduct 1.50 and end in 6. Possible?