How do we repeat an equation on all the rows? Endlessly, as we enter data in other columns of the row, I want equation to calculate. Technically creating a new row everyday but I want to calculate as I begin entering data for that row.
I have 5 columns: A = Date. B, C and D = Are used to enter daily data. E = Equation (B+C-D). So every day I will have a user enter data in B, C, and D. I want the date and the equation to come up as soon as they enter the data in B, C, or D.