How can I fix formula to a row so that when data is inputted in any cell within that column, it auto-computed in Google Sheets? the % doesn't work
Without having to drag the formula down.
Example:
Column H contains data calculated from column B + E
-
share a copy of your sheet – user0 May 9 '19 at 17:26
-
docs.google.com/spreadsheets/d/… – Sinethemba Gayiza May 9 '19 at 17:39
-
I want to calculate Overtime Rate by multiplying Hourly Rate by 1.5 (found in the Employees Sheet – Sinethemba Gayiza May 9 '19 at 17:41
=ARRAYFORMULA(IF(LEN(B2:B&E2:E), B2:B+E2:E, ))
