Latitude & Longitude

To Calculate Lat & Long in Excel

Formula for Degree Decimals to Deg Min Sec

Example: 1.2267 in C2
Get it in 1 cell, enter formula, =TEXT(C2/24,"[h]° mm' ss'' ")
Get it in 3 diff cells, enter as follows
for Degrees, =INT(C2)
for Minutes, =MINUTE(C2/24)
for Seconds, =SECOND(C2/24)

Formula for Deg Min Sec to Degree Decimals

If in 3 Different Cells,
Example: 1° in C1, 13' in D1, 36" in E1
Enter Formula, =C1 + D1/60 + E1/60/60

Roman Numerals

Roman numerals are written using the seven letters of the alphabet (shown in Table)

There are certain rules when using Roman numerals:

Letters are arranged from the largest to smallest.

Numbers are added to arrive at the value.

• For example XVI is X (10) +V (5) + I (1) = 16.

When a smaller number precede a larger number, the smaller is subtracted from the larger.

• For example: IX is 1 (I) subtracted from 10 (X) = 9.

Roman Numeral	Number
I	1
V	5
X	10
L	50
C	100
D	500
M	1000

For bigger number, i.e ≥ 5K, an overbar is used

Blank Cells

Fill Blank Cells of Title Cell

To fill blank cells
Steps as follows:

• Find blank cells using Go To Special [Find & Select, Editing, Home Tab]
• When blank cells selected Press Ctrl Key
• Enter =above cell [e.g. =A1] in formula bar
• Press Ctrl + Enter

Replace Code

For Replacing

Paragraph Mark, ¶	^p
Tab	^9
¬	Alt 170

Alt Code

For Editing

Alt 0215		×		Multiply
Alt 246		÷		Divide
Alt 0247		÷		Divide
Alt 241		±		Plus Minus
Alt 242		≥		More / Equal
Alt 243		≤		Less / Equal
Alt 0137		‰		Per Mille
Alt 248		°		Degree
Alt 230		µ		Mu
Alt 250		·		Middle
Alt 20		¶		Paragraph Mark
Alt 10003		✓		Check Mark (only in Word)
Alt 251		√		Root

Conditional Formatting

Conditional Formatting

To alternate row colours

Steps as follows:

• Choose New Rule [Conditional Formatting, Styles, Home Tab]
• Click use a formula to determine which cells to format [Select a Rule Type]
• Enter formula: [Edit the Rule Description]
• =mod(row(),2)
• Set colours by clicking Format
• Use Fill Tab

Other alternating formulas as follows:

• 2 rows, =mod(row(),4)<2
• 3 rows, =mod(row(),6)<3
• ...
• ...