Question about Corel WordPerfect Office X4 Home & Student Edition Full Version Academic License for PC
When you include addresses like A2, C10, F15 they are relative addresses .eg: If you have entries like:
in B4 you have saturday
in C6 you have the formula =FIND("a",B4) .....the answer is 2
B4 is a relative cell address, because if you copy the formula across the row, OR up/down the column, the formula changes and the answer changes
To make it an absolute address you have to type a $ in the cell address. If you type the cell address formula as $B4, it means wherever you move to or copy the formula the B will not change
If you type B$4 the row no 4 is ABSOLUTE or fixed.
$B$4, both column B and row 4 are fixed. If you move the formula anywhere the cell reference will not change.
Summary B4 is a relative cell address
$B4 is absolute address (B is fixed)
B$4 is absolute address (4 is fixed)
$B$4 is abso;lute address (Bis fixed, 4 is also fixed)
Hope this answers your question
Posted on Sep 06, 2009
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
Tips for a great answer:
May 07, 2017 | Computers & Internet
Dec 27, 2014 | PayPal Computers & Internet
Feb 04, 2014 | Google Computers & Internet
Jan 07, 2014 | Facebook Social Network
Mar 17, 2011 | Toshiba E-Studio 3511 Color Copier
Oct 27, 2010 | Garmin nuvi 1300 Car GPS Receiver
Oct 06, 2010 | Western Digital 500GB My Book World...
Mar 08, 2010 | Sony Ericsson W350A Cell Phone
Dec 10, 2008 | Tomtom ONE 3rd Edition GPS
Aug 15, 2008 | Computers & Internet
137 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: