Dear Friend,
thanks for help.
I have asked in cell a1 contains (134SQM) and cell a2 contains (120SQM) then how to do the multiplication. This numbers can change in digit and the unit of measurement also changes in digit (SQM = 3 digits, LM=2 digit, Nos. = 4 digit)
Kindly help.
Could you please help me to get the sum result in each row as given below.
QTY RATE (BD) TOTAL AMOUNT
134 SQM 120 SQM (134*120)
66 SQM 120 SQM (66*120)
25 SQM 120 SQM
3 Nos. 100 per number
56 SQM 135 SQM
31 SQM 135 SQM
40 SQM 45 SQM
3 SET 100 SET
2530 SQM 10 SET
1745...