Current location - Loan Platform Complete Network - Big data management - If the formula in cell A5 is "=AVERAGE(B$2:B$5)", the formula will become after being copied to cell B2.
If the formula in cell A5 is "=AVERAGE(B$2:B$5)", the formula will become after being copied to cell B2.
I don't quite understand the landlord's problem.

However, I would like to explain the reference meaning of this formula, which may give some hints to the landlord:

The cells referenced in the formula of p>A5 cell are B$2:B$5, which means that lines 2-5 of the right column of the formula are referenced!

so after copying to B2, the reference is still "lines 2-5 of column 1 on the right of the column where the formula is located", that is C2: C5 (column 1 on the right of b2 is column C, and the actual formula will become: =AVERAGE(C$2:C$5))!

Therefore, if the landlord feels that the formula result is wrong, please check: 1)C2:C5 data; 2) Check whether the reference method of the formula itself is what you want.

if you have any questions, please Hi me or send me a Baidu message

GoodLuck!

Related articles
  • What are the second university in Chongqing
  • May IP exhibitions become a good business
  • What are the foundational strategies for digital transformation
  • Summary of Suqian Big Data Sales Method
  • Funny segments that make people die laughing
  • Domestic top ten companies of face recognition (which is the best company for face recognition)
  • How to migrate sqlserver data to mysql database and precautions needed
  • China's top ten professions in short supply
  • Intelligent library construction and management problems and countermeasures essay
  • The first thing you need to do is to get your hands on a new one, and you'll be able to do it in a way that's easy to understand.

    • copyright 2024 Loan Platform Complete Network All rights reserved