xyz

Hello everyone, I know this is probably easy - but for some reason I'm having trouble with getting a formula to work correctly. I am trying to populate a certain value in Column D based on different criteria in Column F. Column F will contain "ABC Employee Name" or "XYZ Employee Name" or...

I am trying to figure a better method than using a Nested IF statement with 18 IFs. The below example is only 3 IFs, but my data has 18 columns of amounts. I have to assign an Account_No based on if there is a value in an Amount column. I couldn't figure out how to use VLOOKUP for this. Not...

I want to convert XYZ to Lat Long and viceversa, but I don't know how. I have found many spreadsheets on the internet, but none of the ones I've tried seem to work correctly. Can someone please share with with me a spreadsheet that can do this the right way? Thanks in advance.

Hi all, I have a set of spatial data (X,Y,Z) that I wish to rank in excel. The aim is to be able to list the data points from East to West, North to South (and if possible North-East to South-West but this is less important for now). An added difficulty with this is that not all data points...

Need some modern Excel functions for science students and astronomy. On www there are a multitude of UDF that calculate astronomical values. Most of these use an index and repeat the same pre calculation three times to get information like x y z or radius theta phi ... and repeat the same 3...

My problem relates to a computer model of a building. I have thousands of nodes output from the model each of which has stress values associated with it. Each nodes has an X, Y, Z value describing it's location in 3D space. The strength properties of the building are assigned in hundreds of...