Help with nested If(ISERROR) function

Hello-

I'm a newbie to the forum and am entirely self-taught in excel. While I've wound up with a better-than-the-average-amateur skill set, I'm stumped on a formula I'm trying to get to work.

I'm attempting to get a product based on input from another cell which may be variable. For example, the information may appear as (2 digits)*(2 digits) or (2 digits)*(1 digit) or (1 digit)*(1 digit). In other words, 12x10, 12x8, or 8x8. I was able to get as far as

=IF(ISERROR(LEFT(C22,2)*RIGHT(C22,2)),LEFT(C22,2)*RIGHT(C22,1), LEFT(C22,2)*RIGHT(C22,2))

but haven't been able to construct a statement that will allow me the additional step(s) of calculating if the input is "8x8" or "8x12." I had attempted

=IF(ISERROR(LEFT(C22,2)*RIGHT(C22,2)),LEFT(C22,2)*RIGHT(C22,1),IF(ISERROR(LEFT(C22,2)*RIGHT(C22,1)),LEFT(C22,1)*RIGHT(C22,1),LEFT(C22,2)*RIGHT(C22,2)))

but I know I'm missing something.

My worksheet relies on information input by others, so 12x8 sometimes appears as 8x12, so I'm hoping to include a rule for that, as well.

Any assistance is incredibly appreciated.

Thank you!

That didn't work; it's returning #VALUE! as the answer. Should the above formula be used to replace the entire formula I had, or should it replace only a portion?

workbook for Excel forum help.xls

This workbook is for real estate valuation. I have my own way of doing it. It could take a really long time, so I came up with this. The problem is that room dimensions are sometimes 12x12 (two by two), which works fine, or 12x9 (two by one), and sometimes 9x9 (one by one). I figured out how to do two by two and two by one. The problem arises when the dimensions are entered by another user as 9x12 (one by two) or 9x9 (one by one). I haven't been able to get it to work. E22's formula is what I have that works if the entered values are two by two or two by one. E25's formula is was I attempted to get further, but it doesn't work. If I switch 10x7 to 7x10, I get #VALUE! I am at the present limit of what I can guess.

Additionally, while we're here, you'll see #VALUE! in E28-E32. There are blank fields in the B and C columns which would auto-populate were the listing information to employ them. I was able to figure out how to get the B and C cells to show as blank but not the E cells. What am I doing wrong there? Or is it because those cells rely on information from another sheet, maybe? Lost.

Thanks, THANKS, to all for their input and assistance. I am not a "math" person by nature or training.

Thank you! That works wonderfully. I don't completely understand it, but it works great. (Sorry it took me a couple days to get back here.)