HOW TO DO FUNCTION

[wheelu4]

If I want the price of column (A2:A2037) (A1=MSRP) to minus 15% and = column
(B2:B2037)(B1=Sale Price) ---What formula would I use? I've tried several
with no luck---thanks

 

[Pete_UK]

Do you mean that you have the sales price in column B, and you want to
set the values in column A to be 15% less than the sales price?

If so, put this formula in A2:

=B2 * 85%

However, if the sales price should be 15% more than MSRP, then you
will need to do it this way:

=B2 / 1.15

Copy the formula down.

Hope this helps.

Pete

 

[John]

Sorry but it's not cleat to me.
Are you asking to reduce the prices of column A and column B of 15%.
If so put in column C2 , =a2*0.85 and drag down to C2037,after do the same
in column D =b2*085
Regards
John