I'm trying to simplify my spreadsheet
I have a spreadsheet that imports data from a table on a website. Sometimes this data is a percentage in decimal format, and sometimes the website doesn't have precise data, so it gives two numbers. For example, "7-13%". I use =SPLIT to separate these two numbers into Columns D & E, then in Column F, I convert them to decimal percent and average them. This percentage is then multiplied by the contents of Column B
Is there a simpler way to do this, and compress it down into one column instead of three?