Hi experts/ Brad
Id like to make some adjustments (conditions) to the source code of the previous workbook please: https://www.experts-exchange.com/Q_28072893.html
1. If there is no entry in col "D" then nothing is to be shown in col "E"
2. If there is only a text entry in col "D" then nothing is to be shown in col "E"
3. If there are 2 values in col "D" ie
porch 2.00L x 5.00W
alfresco 3.00L x 3.00W
then col "E" multiplies these 2 values, then adds the total of them so, the result would be 10.00 + 9.00 (the result of the porch + alfresco) = 19.00
4. I have found a problem where if i enter the following information;
Front: 10.56 m2
Rear Garage: 5.28 m2
Rear Pedestrian: 1.67 m2
The result should = 17.51, but instead = 23.51, please adjust code so that if there is an "m" followed by a number it does not add the value