Quantity surveyors, Accountants and others who are always/often using the MS Excel, sometime they used to feel uncomfortable when accessing Excel. Because of time. There are expert using many formulas in excel, it will save the time & to be accurate.
Here one small tips added, when multiplying the 2 or more cells if we use the normal formula like =ROUND(C6*E6,3)[See the Figure No.1], we wants to paste on every cells, only where required. Unless if we tracked that formula, then it will show 0.000 value, where multiple factors’ cells are blank.
Table No.1
To avoid this, the following formula will useful.=IF(C6="","",C6*E6) [See the Figure No.2],
Table No.2
Try it on your work.
No comments:
Post a Comment