Skip to content

12m-15m.org

Tin Tức Việt Nam – Thế Giới Lớn Nhất

  • Giải Trí
  • Công Nghệ
  • Ẩm Thực
  • Khỏe Đẹp
  • Môi Trường
  • Bất Động Sản
  • Giáo Dục
  • Khác
    • Công Nghiệp
    • Hành Chính và Dịch Vụ
    • Nông Nghiệp
    • Ô Tô, Xe Máy, Xe Khác
    • Tài Chính, Ngân Hàng, Bảo Hiểm
    • Thông Tin và Truyền Thông
    • Vận Tải
    • Xây Dựng
  • Tin HOT
  • Phim
Menu

How to Use Excel 2010 absolute reference

Posted on March 27, 2021 by admin



In this tutorial you will learn how to use absolute references for Excel formulas

Don’t forget to check out our site for more free how-to videos!
– our feed
– join us on facebook
– our group in Google+

The default setting in Excel is to have relative formulas, but sometimes making them have absolute references is useful — this tutorial is going to show you how to use excel absolute reference for formulas.

Step # 1 — Identifying the Formula for being made Absolute

Start Excel with the sheet where you need to create an absolute reference. In this example you can see that we are dividing the “TOTAL” by the “Number of Shops” to give the “Split between shops”. This is done with a simple SUM formula, which you can see in cell “C8”. This is currently a relative formula and if we move it to cell “C8” to calculate the split for 2012 it will not work.

Step # 2 — Making Part of the Formula Absolute

This formula needs to be made absolute so it will always reference the value in cell “B7”. Click on the cell, “B8” in this case, to edit the formula. To make the “B7” value absolute, delete “B7” and type “$B$7” — dollar signs in these locations make the value absolute.

Step # 3 — Completing the Calculation with the Absolute Reference

Press return to complete the change to the formula. Now when you try and copy the formula to the adjacent cell there will not be an error and the “TOTAL” will be divided by 3. This is how to use excel absolute reference and you can see it successfully gives us a result of “60.5”

Nguồn: https://12m-15m.org/

Xem thêm bài viết khác: https://12m-15m.org/category/cong-nghe

Posted in Công Nghệ

Post navigation

Sẽ Có $1200 lần 2! Mnuchin nói gì về PPP lần 1: audit, forgivess trong buổi TESTIMONY
[15/03/2021] Đọc sách nhé: Sách của Inamori Kazuo – Ngày 05

Related Post

  • Ứng dụng Aiai Live là gì? Live Stream trực tiếp tiện lợi
  • nen-chon-chuong-trinh-vay-tien-nao Nên chọn chương trình vay tiền nào tốt nhất hiện nay?
  • DỊCH VỤ GIẶT LÀ – NHU CẦU NGÀY CÀNG TĂNG LÊN CỦA XÃ HỘI
  • Hướng dẫn đặt mật khẩu và xoá mật khẩu cho file PowerPoint
  • Microsoft Excel 2019 dành cho mọi người – Tập 2-2
  • Chia sẻ về cách sử dụng MS Teams phiên bản 2011

9 thoughts on “How to Use Excel 2010 absolute reference”

  1. Excel, Word and PowerPoint Tutorials from Howtech says:
    March 27, 2021 at 2:53 pm

    ❗ Subscribe To Our Main YouTube Channel

    https://www.youtube.com/user/howtechpc

    Reply
  2. Jim 2000 says:
    March 27, 2021 at 2:53 pm

    Perfectly explained. Clear, quick, and concise. Much appreciated it.

    Reply
  3. Martin Rodriguez says:
    March 27, 2021 at 2:53 pm

    I come from the year 2020… your tutorial indeed help me out

    Reply
  4. Elif Taş says:
    March 27, 2021 at 2:53 pm

    Using fn f4 is another option.

    Reply
  5. HearMyWordz d says:
    March 27, 2021 at 2:53 pm

    Thanks

    Reply
  6. elsamso says:
    March 27, 2021 at 2:53 pm

    thanks!

    Reply
  7. Steven Lee says:
    March 27, 2021 at 2:53 pm

    alternatively, F4

    Reply
  8. Pope Josh VII says:
    March 27, 2021 at 2:53 pm

    Dat voice

    Reply
  9. Archon_MR says:
    March 27, 2021 at 2:53 pm

    Thank you very much!

    Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Theme Design & Developed By OpenSumo