HOW TO DO FUNCTION
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 |
HOW TO DO FUNCTION
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 On Nov 27, 11:50*pm, wheelu4 wrote: 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 |
HOW TO DO FUNCTION
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 "wheelu4" wrote in message ... 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 |
All times are GMT +1. The time now is 11:27 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com