Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
String of functions confusion - please help
I will try to explain this the best I can.
I want to multiple a series of cells say C4:T4 by a specific percent, then with that product I want to subtract it from the original number, so it would be some thing like this: 100*.03= 3 then 100-3 = 97 That "97" is what I need to be replaced in each cell. I have no idea how to do this at all. If someone could give me some guidance that would be great. Thank you |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
String of functions confusion - please help
Enter
..97 in a new, unused cell. Then, right click in that cell and choose "Copy". Select C4 to T4, Right click in that selection and choose "Paste Special". Click on "Multiply", Then <OK. -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Ashlee" wrote in message ... I will try to explain this the best I can. I want to multiple a series of cells say C4:T4 by a specific percent, then with that product I want to subtract it from the original number, so it would be some thing like this: 100*.03= 3 then 100-3 = 97 That "97" is what I need to be replaced in each cell. I have no idea how to do this at all. If someone could give me some guidance that would be great. Thank you |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
String of functions confusion - please help
I will try to explain this the best I can.
I want to multiple a series of cells say C4:T4 by a specific percent, then with that product I want to subtract it from the original number, so it would be some thing like this: 100*.03= 3 then 100-3 = 97 That "97" is what I need to be replaced in each cell. I have no idea how to do this at all. If someone could give me some guidance that would be great. You are asking to physically replace the values you have with their percentage reduction, right? And that percentage value is going to be the same for each cell, right? Okay, try this. Put 0.97 (1 minus the percentage value) in a cell somewhere; then select that cell and press Ctrl+C (or click Edit/Copy from Excel's menu bar); next select all of the cells you want to do this calculation to; then click Edit/PasteSpecial from Excel's menu bar; select Multiply from the Operation section of the dialog box that appeared and then click the OK button. You can now press Esc to unselect the cell with the 0.97 in it and then clear it. Rick |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Confusion | Excel Worksheet Functions | |||
Confusion..... | Excel Discussion (Misc queries) | |||
Month day confusion | Excel Worksheet Functions | |||
STRING functions | Excel Worksheet Functions | |||
still have drop-down confusion | Excel Discussion (Misc queries) |