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.