Combine IF statements and display results seperately

I'm making a random weather generator for a game and I'm wanting it to combine the temperature, rainfall and wind formulas into one and have the results display as: XX*F with 0.XX'' precipitation and XXmph winds
I'm not sure if this is even possible, but I figure if it is, someone here will know. Thanks in advance for any help.

Temperature (Currently displays as XX*F):

Precipitation (Currently displays as X.XX"):

=IF(RANDBETWEEN(1,100)<41,RANDBETWEEN(5,10)/100,0)

Wind (Currently displays as XXmph):

=IF('[Random Weather.xlsx]Reference'!AC2<71,RANDBETWEEN(0,10),IF('[Random Weather.xlsx]Reference'!AC2<81,RANDBETWEEN(11,20),IF('[Random Weather.xlsx]Reference'!AC2<91,RANDBETWEEN(21,30),IF('[Random Weather.xlsx]Reference'!AC2<99,RANDBETWEEN(31,50),IF('[Random Weather.xlsx]Reference'!AC2<100,RANDBETWEEN(51,74),RANDBETWEEN(175,300))))))

There are 72 variations of each of these formulas (based on location and date), so if you do know a way to combine the formulas and make the results display in the desired manner, hopefully you know a trick to quickly do so? The goal here is to clean up the sheet. In total each of the 72 variations is used 84 times for 6048 formulas and results.

As a separate but equal situation, I'd like to narrow this whole spreadsheet even further. Ideally, my end result would all you to enter a season (Spring, Summer, Autumn, Winter) and a Biome (Tundra, Plains, Evergreen Forest, Desert, Deciduous Forest, Jungle, Glacial Coast, Coast, Tropical Coast, Arctic Mountains, Mountains, Tropic Peaks, Rolling Tundra, Highlands, Plateaus, Boreal Bog, Swamp, Cloud Forest) and the Temperature, Precipitation, and Wind Speed be displayed. I understand that essentially this is a huge series of IF formulas, but I'm not sure if Excel would allow me to string that many together. If anyone would like to give me a hand with this, let me know and I'll post all the formulas.

Whoops, forgot the Temperature formula!

=IF('[Random Weather.xlsx]Reference'!Y2<71,ROUNDUP(RANDBETWEEN(28,33),0),IF('[Random Weather.xlsx]Reference'!Y2<86,ROUNDUP(RANDBETWEEN(22,27),0),ROUNDUP(RANDBETWEEN(33,39),0)))

I think I attached a mock up this time. If the mock up is not clear, let me know. Thanks.

Because the Temperature values, amount of Precipitation and Wind Speeds are all randomly generated each time, I just entered them as they were currently displayed (changing every time I finished one line). Essentially though, it would be

Environment Weather
Tundra XX°F with X.XX'' Precipitation and XXmph winds.
Plains XX°F with X.XX'' Precipitation and XXmph winds.
Evergreen XX°F with X.XX'' Precipitation and XXmph winds.
Desert XX°F with X.XX'' Precipitation and XXmph winds.
Deciduous Forest XX°F with X.XX'' Precipitation and XXmph winds.
Jungle XX°F with X.XX'' Precipitation and XXmph winds.
Glacial Coast XX°F with X.XX'' Precipitation and XXmph winds.
Coast XX°F with X.XX'' Precipitation and XXmph winds.

Where XX is found using the formula appropriate to the Environment listed in BEFORE #1, X.XX"

Apologies, but it is 5:50 AM here and I've been up since 4:00 AM yesterday, so I'm a little tired and may have overlooked something when I made the mock up.

Another way to put it is that I want to know if it is possible to get the results {{It is =IF('[Random Weather.xlsx]Reference'!A65<71,ROUNDUP(RANDBETWEEN(28,33),0),IF('[Random Weather.xlsx]Reference'!A65<86,ROUNDUP(RANDBETWEEN(22,27),0),ROUNDUP(RANDBETWEEN(33,39),0)))°F with =IF(RANDBETWEEN(1,100)<41,RANDBETWEEN(5,10)/100,0)'' and =IF('[Random Weather.xlsx]Reference'!E65<71,RANDBETWEEN(0,10),IF('[Random Weather.xlsx]Reference'!E65<81,RANDBETWEEN(11,20),IF('[Random Weather.xlsx]Reference'!E65<91,RANDBETWEEN(21,30),IF('[Random Weather.xlsx]Reference'!E65<99,RANDBETWEEN(31,50),IF('[Random Weather.xlsx]Reference'!E65<100,RANDBETWEEN(51,74),RANDBETWEEN(175,300))))))mph winds}} to display in a single cell with the formulas actually displaying the results they would calculate.

Alright, thanks for trying.

That is the exact solution I was looking for to solve the first issue I was having. Thank you very much!

My second issue is a basic parsing issue with IF formulas. I'm trying to combine a series IF formulas that are in separate cells into a single long IF formula. Here are four of the IF formulas I'm trying to combine.

=IF(A2="Tundra, Spring",IF(Reference!A2<71,ROUNDUP(RANDBETWEEN(28,33),0),IF(Reference!A2<86,ROUNDUP(RANDBETWEEN(22,27),0),ROUNDUP(RANDBETWEEN(33,39),0))))

=IF(A2="Tundra, Summer",IF(Reference!E2<71,ROUNDUP(RANDBETWEEN(55,72),0),IF(Reference!E2<91,ROUNDUP(RANDBETWEEN(42,54),0),ROUNDUP(RANDBETWEEN(73,85),0))))

=IF(A2="Tundra, Autumn",IF(Reference!F2<71,ROUNDUP(RANDBETWEEN(-32,-15),0),IF(Reference!F2<86,ROUNDUP(RANDBETWEEN(-43,-31),0),ROUNDUP(RANDBETWEEN(-14,-3),0))))

=IF(A2="Tundra, Winter",IF(Reference!G2<71,ROUNDUP(RANDBETWEEN(-48,-30),0),IF(Reference!G2<81,ROUNDUP(RANDBETWEEN(-58,-47),0),ROUNDUP(RANDBETWEEN(-29,-18),0))))

The end goal is that I want to be able to use a drop down list to select a "Biome, Season" and get the results based on that. I'll attach a mock up below, hopefully this one will be clearer.

New issue

With nesting all the Biome/Season temperatures together, I realized I will need a total of 216 nested IF formulas and it is my understanding that there is a maximum of 64 nested IF formulas. If I divide it into 4 sections, one section for each Season, then I need 72 nest IF functions per Season. Is there any way around these limitations? If not, this issue cannot be resolved.

I didn't see your reply yet, disregard the "New Issue" until I test your solution.

Wow, you're great! Thank you so much. You just resolved an issue I've been working on for 2 days in a matter of hours!