Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
Nested IF Function, Date Comparing, and NetworkDays Function | Excel Worksheet Functions |