Excel 2013 - how to keep a formula consisten


  1. ChrisPbass
    Posts : 317
    7 Ultimate 64 bit
       New #1

    Excel 2013 - how to keep a formula consisten


    Hi

    I am trying to tie one cell into a formula that is being pasted into multiple rows.
    I know you can use $ to keep the cell consistent but it doesn't seem to be working.

    So if the value is in c9 and then first row gets c9 then the new row gets c10 etc... I need it to be c9 throughout the column.
      My Computer
    Quote Quote

  3. strollin
    Posts : 3,371
    W10 Pro desktop, W11 laptop, W11 Pro tablet (all 64-bit)
       New #2

    You use $C9 to keep the column consistent, C$9 to keep the row consistent and $C$9 to keep the cell consistent. Are you doing that and it's not working?
      My Computer
    Quote Quote

  4. ChrisPbass
    Posts : 317
    7 Ultimate 64 bit
    Thread Starter
       New #3

    strollin said:
    You use $C9 to keep the column consistent, C$9 to keep the row consistent and $C$9 to keep the cell consistent. Are you doing that and it's not working?

    DOH i was doing $c9 and c$9. That works great. Thanks.
      My Computer
    Quote Quote

 

  Related Discussions
I am using Win 7 Pro 7601 Multiprocessor Free SP1, 64-bit. Intel Core i7-4770, 16GB installed memory. Excel 2016. I have a spreadsheet with formulas, none of which display in the formula bar. All my other spreadsheets display their formulas in the bar. I have tried the following to display the...
Excel Formula
in Microsoft Office

Hello Sir, Can you let me know the formula in Excel: I have a table as below: 309779 This table, At the column "A,Status" when i Put the word" Completed", it's will automatic put current Date to Column "B, Row 2". But i don't know after that when tomorrow arrived,at the column "B,Row...
Excel 2003 sum formula problem
in Microsoft Office

I have been entering currency data in Column B in Euros to an EXCEL 2003 s/s and the formula used has added these totals entered in that Column correctly until I reached a total sum of 74364.70 Euros ,this being the sum of entries in Rows B6 to B82 . This was reached with the formula showing as...
Excel Formula Help please...
in Microsoft Office

This is probably very simple and I have got it working but it isn't working how I want it to work. I have created an Excel document to show my monthly payments of a bank loan. I have created 3 columns in the first column is the payment number, in the second column is the amount that the loan...
Hi I'm unable to scroll while editig a formula in excel 2007. i know it can be done if i edit directly in cell but i prefer editing in the formula bar. I've seen an apparent solution in some forum which says change the mouse setting in the control panel (the wheel tab). Start --> Settings -->...
Our Sites
Site Links
About Us
Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

 © Designer Media Ltd
All times are GMT -5. The time now is 06:59.
Find Us