-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
dms
-
P
Ignore Blank Cells When Creating A Formula
Below is a journal voucher. I would like to extract the data to post in our DMS. I run into a problem when there are blank cells. I want to be able to go from left (debit entry) to right (credit entry). I initially wrote this two part formula: The debit formula: The first cell has to be by...- promoe
- Thread
- blank cell credit dms formula
- Replies: 1
- Forum: Excel Questions
-
S
DD to DMS conversion without rounding.
I stole this from IML on June 25, 2001 11:43 AM tried to PM but I'm new so please don't harp on me too much please! Assuming your number is A1, try the following =INT(A1)&CHAR(186)&" "&INT((A1-INT(A1))*60)&CHAR(145)&" "&ROUND((((+A1-INT(A1))*60)-INT((+A1-INT(A1))*60)),2)*60&CHAR(145) The...- Skylar289
- Thread
- conversion degree decimal degree minutes seconds dms lat/long conversion
- Replies: 5
- Forum: Excel Questions
-
M
DMS to decimal and back again
Hi there I am wondering if anyone can help me. I am working in longitude and latitudes in the southern hemisphere (Latitudes are negative) I have put in the following cell formula =TEXT(INT(G17),"0° ")&TEXT(INT((G17-INT(G17))*60),"0' ")&TEXT((G17*60-INT(G17*60))*60,"0.0000")&"""" but the...- Mattfa
- Thread
- decimal dms latitude longitude
- Replies: 3
- Forum: Excel Questions
