0

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.

8
  • 1
    Just drag it down the column.. Feb 2 '15 at 16:31
  • Is your question about how to get the same equation in every row, or how to have pre-populated equations not display anything until there is input?
    – fixer1234
    Feb 2 '15 at 16:35
  • im assuming the prepopulated equations. my sheet is protected and the unlocked cells i call the "data entry" cells. I want a user to enter the data and when the first cell is entered with data i want the equation to display a number. I want this to occur on all the rows of the sheet. Thanks!
    – user414766
    Feb 2 '15 at 17:15
  • The above information, in your comment, is important to share in your question. Details help us help you. What have you attempted so far? Can you give us an example how your data is set up?
    – CharlieRB
    Feb 2 '15 at 17:35
  • 3
    You could probably use a table. That would automatically add formulas (and formatting) as entries are made in new rows. Feb 2 '15 at 18:35
1

Type the following nested function in cell E2 then past it into the entire column:

=IF(AND(B2="",C2="",D2=""),"",B2+C2-D2)

Same with the Date for column A. Type the following nested function in cell A3:

=IF(AND(B3="",C3="",D3=""),"",A2+1)

Past it into the entire column, and type the first date in cell A2.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.