• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

Absolute and Relative formula

Extracts from this document...

Introduction

Absolute and Relative Formula Absolute and Relative formula In my spreadsheet I will be using both absolute and relative formula. Relative formula is where for example you add the contents of two cells together, and when you copy the formula and paste it into another cell, the formula the re-calculates by adding the contents of the two new cells and say if I copied and pasted the formula into another new cell, it wouldn't work this time because in one of the content it is non numeric. But if I wanted to transfer the all the answer into one cell but this time on to another sheet, then the formula wouldn't work because this time you need an Absolute formula to transfer all the answer into another sheet, for this you can't just use a ...read more.

Middle

Relative Formula This formula adds the content of the two green cells together. A B C 1 13 7 20 A B C 1 13 7 =SUM(C10+D10) If you copy and paste the formula in cell C1 into cell C2, the formula re-calculates by adding the two yellow cells together. A B C 2 11 7 If you copy and paste the formula in cell C1 into cell C3, the formula re-calculates by adding the two green cells together. You will notice that an error message occurs which say "Value". This means that the formula will not work because the data in cell A3 is not numeric. A B C 3 Words 15 If you want to transfer the answer shown in cell C1 (i.e. ...read more.

Conclusion

A B C 1 I will use these two formulas on the sales sheet so that I can transfer the total cost per item onto another sheet. Other Formula Coding Coding is essential in my spreadsheet for receipts and ordering forms. To create my codes I will be using the concatenate formula. However this formula can be used to join together data contained in different cells, meaning it can take the first few letters, last few letters and also middle letters too. Therefore I will take the first few letters of the first word. I will then put them together by adding few numbers (this gives the identity of the item) and I will be putting these numbers together by the concatenate formula to give me the detail of the item, how many are in stock and what's the price. ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our AS and A Level Molecules & Cells section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work