How do I create a formula with multiple "if" conditions?
I'm working with a real estate data set. Several thousand rows are missing bathroom data. I'd like to write a formula for a new column that creates bathroom data based on the average bathroom by bedrooms data in the rest of the data set. For example, if baths is missing then beds </= 2 is 1 bath, beds = 3 is 2, beds </= 5 is 3, beds </= 8 is 4, beds >/= 9 is 5. Or, is there a better way to estim...