Need help with Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1509029%22%20slang%3D%22en-US%22%3ENeed%20help%20with%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1509029%22%20slang%3D%22en-US%22%3E%3CP%3EI%20would%20like%20to%20have%20a%20set%20price%20that%20each%20row%20will%20be%20able%20to%20mutiply%20by.%20Example%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20Set%20Cell%20(1F)%26nbsp%3B%20%26nbsp%3B%2428.00%3C%2FP%3E%3CP%3E1%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%208%20*%201F%3D%3C%2FP%3E%3CP%3E2%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%206.5%20*%201F%3D%3C%2FP%3E%3CP%3E3%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%204%20*%201F%3D%3C%2FP%3E%3CP%3EThe%20Set%20Cell%20Can%20vary%20by%20job.%20Copying%20the%20first%20formula%2C%20it%20changes%20the%20next%20line%20to%202F%20and%20the%20next%20to%203F%20so%20on%20and%20so%20forth.%20Is%20there%20a%20way%20to%20make%20each%20line%20reference%20the%26nbsp%3B%201F%20cell%20without%20typing%20each%20one%20individually%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1509029%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1509038%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20help%20with%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1509038%22%20slang%3D%22en-US%22%3ESelect%20File%20%26gt%3B%20Options%20%26gt%3B%20Quick%20Access%20Toolbar.%20Under%20the%20dropdown%20where%20it%20says%20Choose%20commands%20from%2C%20select%20All%20Commands.%20Select%20Help%20from%20the%20list%20of%20commands%20to%20add%20to%20the%20Quick%20Access%20Toolbar.%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1509049%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20help%20with%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1509049%22%20slang%3D%22en-US%22%3E%3CP%3EGot%20that%20done.%20So%20I%20use%20the%20help%20there%20to%20try%20and%20figure%20this%20out%3F%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F493704%22%20target%3D%22_blank%22%3E%40Lewis-H%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1509628%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20help%20with%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1509628%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F722397%22%20target%3D%22_blank%22%3E%40Ronkartz_72%3C%2FA%3E%2C%26nbsp%3Buse%20absolute%20reference%20instead%20of%20relative%20reference%20-%20%24F%241%20instead%20of%20F1.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1509639%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20help%20with%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1509639%22%20slang%3D%22en-US%22%3E%3CP%3EThat%20works!!!%20Thaks%20so%20much%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F383224%22%20target%3D%22_blank%22%3E%40TheAntony%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1509660%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20help%20with%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1509660%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F722397%22%20target%3D%22_blank%22%3E%40Ronkartz_72%3C%2FA%3E%26nbsp%3B%2C%20you%20are%20welcome.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I would like to have a set price that each row will be able to mutiply by. Example

 

                      Set Cell (1F)   $28.00

1        8 * 1F=

2        6.5 * 1F=

3        4 * 1F=

The Set Cell Can vary by job. Copying the first formula, it changes the next line to 2F and the next to 3F so on and so forth. Is there a way to make each line reference the  1F cell without typing each one individually?

5 Replies
Select File > Options > Quick Access Toolbar. Under the dropdown where it says Choose commands from, select All Commands. Select Help from the list of commands to add to the Quick Access Toolbar.

Got that done. So I use the help there to try and figure this out? @Lewis-H 

@Ronkartz_72, use absolute reference instead of relative reference - $F$1 instead of F1.

That works!!! Thaks so much @TheAntony 

@Ronkartz_72 , you are welcome.