ATAN2 Function in Excel | Difference between ATAN2(X,Y) & ATAN2(Y,X)# Survey Camp

Learn how to accurately calculate bearings and angles using the ATAN2 function in Microsoft Excel! In this short but powerful video, we explain the ATAN2 function, its purpose, and the critical difference between ATAN2(x, y) and ATAN2(y, x) — a mistake many beginners make! Whether you're working in surveying, engineering, navigation, or GIS, mastering ATAN2 will help you: ✅ Avoid quadrant errors ✅ Calculate precise azimuths or bearings (0° to 360°) ✅ Eliminate divide-by-zero errors in Excel What You’ll Learn: What is the ATAN2 function in Excel? How does it differ from ATAN? Why the order of x and y matters: ATAN2(x, y) ≠ ATAN2(y, x) How to convert ATAN2 output from radians to degrees Real-world application in bearing calculations (like Gales Table) Timecodes: 00:00 Introduction to ATAN2 Function 1:32 What is ATAN2 in Excel? 2:50 - ATAN2(X,Y) syntax explanation 7:00—ATAN2(Y,X) syntax explanation 11:00 Difference between Atan2(X,Y) and Atan2(Y,X) 13:15 - Real-Life Example: Calculating Bearing Using ATAN2: