I want to determine the area of objects in each row. If values for length and width are present, I want to multiply the values to determine the area of the object. However, for circular objects, the length value indicates the diameter, and the width column is left blank. If there is a value in the length column, but not the width column, the calculation should be
So, given the example table below, the 1st, 2nd, and 4th rows should simply multiply the length by width, while the 3rd and 5th rows should output the
I tried using conditional formatting along with
ISBLANK, but couldn't get it working correctly.
Length | Width 5 | 6 3 | 4 6 | 2 | 6 5 |