Hi, there. I am work on modelling various mechanics of a game on excel. I am taking real time data from here. After importing the data, I tried accessing the data, from another sheet. I am trying to access these values in another sheet for a formula to calculate the temperature at a given altitude. However, the temperature data in the "temperature data" sheet is in °'s and when i try to access them in the other sheet, "temperature", i get an error "A value used in the formula is of wrong data type". When i try taking the values in ° from the "temperature data" sheet in cell i64 (named as "temp") on the "temperature" sheet in the cell B29, i get the above mentioned error in the cell where i am suppose to get the final temperature, E29 in my case.
I can't remove the ° from the "Temperature Data" sheet, because each time i refresh the sheet, i will get the values with °. Is there a workaround for this??
Bookmarks