Print

Print


RE: absolute formula/relative formula

Diddorol dros ben! 

Fformiwla Absoliwt / Fformiwla Berthynol (yn hytrach na chymharol fe dybiwn)

-----Original Message-----
From: Saunders, Tim [mailto:[log in to unmask]]
Sent: 12 November 2003 14:42
To: [log in to unmask]
Subject: absolute formula/relative formula


Pwnc: TGCh
Cyd-destun:  Absolute Formula: In an absolute formula all cells are compared to one value. For instance if you have calculated the average rainfall for each month of the year you may want to have the spreadsheet calculate how much more or less rain there is each month compared to the average. In this example the average rainfall would be found in cell L25. The $ ahead of the column and row make this an absolute formula. Only L7-$L$25 was typed in. The rest were done by using the Fill Down command.

 Relative Formulas: Often times you will want to use a formula that adds or subtracts to values in your spreadsheet. In this example the temperature range for each month was calculated by subtracting the low from the high for each month. No one would want to type this in 12 times. You would enter the first one in cell N7 and then use the Fill Down* shortcut to copy the formula. In every case you would want to use the L and M value beside each other. The computer automatically changes this for you. This is called a relative formula. It modifies the formula relative to the cell the answer is going into.


Syniadau? Awgrymiadau? Cynghorion? Cyfarwyddyd? Cynseiliau cedyrn?

Tim
Tim Saunders
Cyfieithydd / Translator
Uned Cyfieithu Cyngor Rhondda Cynon Taf / Rhondda Cynon Taf Council Translation Unit  Ty Trevithick
Abercynon
Rhondda Cynon Taf CF45 4UQ
Ffôn +44-(0)-01443-744418



Nid yw'r e-bost hwn nag unrhyw ffeiliau a drosglwyddir gydag ef o angenrheidrwydd yn adlewyrchu barn Cyngor Rhondda Cynon Taf.

Mae'r wybodaeth sydd yn y ddogfen hon yn gyfrinachol. Fe all fod yn gyfreithiol freintiedig.
Bwriedir yr e-bost ar gyfer y person neu'r sefydliad a enwir uchod. Os derbyniwyd yr e-bost hwn trwy gamgymeriad,
dylid hysbysu'r anfonydd a dileu'r e-bost oddi ar eich system os gwelwch yn dda.
Os mai nid i chi y bwriadwyd ef ac nid chi yw'r cyflogwr na'r asiant sy'n gyfrifol am roi'r e-bost i'r derbynnydd bwriadedig,

fe'ch hysbysir gan hyn na chaniateir i chi ddefnyddio, adolygu, lledaenu, dosbarthu na chopio'r e-bost ar unrhyw gyfrif.

Fe all fod gwneud hynny yn anghyfreithlon.


This e-mail and any files transmitted with it are not necessarily the view of Rhondda Cynon Taf Council. The information contained in this communication is confidential. It may be legally privileged.

It is intended only for the person or entity named above.
If you have received this e-mail in error please notify originator and erase this e-mail from your system.
If you are not the intended recipient or the employer or agent responsible for delivering it to the
intended recipient, you are hereby notified that any use, review, dissemination, distribution or copying
of the e-mail is strictly prohibited. To do so may be unlawful.


Nid yw'r e-bost hwn nag unrhyw ffeiliau a drosglwyddir gydag ef o angenrheidrwydd yn adlewyrchu barn Heddlu Gogledd Cymru.
Mae'r wybodaeth sydd yn y ddogfen hon yn gyfrinachol. Fe all fod yn gyfreithiol freintiedig.
Bwriedir yr e-bost ar gyfer y person neu'r sefydliad a enwir uchod. Os derbyniwyd yr e-bost hwn trwy gamgymeriad,
dylid hysbysu'r anfonydd a dileu'r e-bost oddi ar eich system os gwelwch yn dda.
Os mai nid i chi y bwriadwyd ef ac nid chi yw'r cyflogwr na'r asiant sy'n gyfrifol am roi'r e-bost i'r derbynnydd bwriadedig,
fe'ch hysbysir gan hyn na chaniateir i chi ddefnyddio, adolygu, lledaenu, dosbarthu na chopio'r e-bost ar unrhyw gyfrif.
Fe all fod gwneud hynny yn anghyfreithlon.


This e-mail and any files transmitted with it are not necessarily the view of North Wales Police.
The information contained in this communication is confidential. It may be legally privileged.
It is intended only for the person or entity named above.
If you have received this e-mail in error please notify originator and erase this e-mail from your system.
If you are not the intended recipient or the employer or agent responsible for delivering it to the
intended recipient, you are hereby notified that any use, review, dissemination, distribution or copying
of the e-mail is strictly prohibited. To do so may be unlawful.