Could anyone help me with an IF formula in excel?

TechnicalJayTechnicalJay Member Posts: 219 ■■■□□□□□□□
Hello,

I'm working on a spreadsheet for replacing old computers. The Columns I have are Users, Desktops, Completed, Laptops, Completed. The rows would be all the user's names and the very last row would be 'Total Replacements Needed' with the total number of desktops need under the desktop column and the number of laptops needed under the laptop column.

Is there a formula or function so I could put '1'(meaning completed) or '0'(not completed) under the completed column and it would automatically subtract it from the Total Replacements Needed number?

Thank you.

Comments

  • p@r0tuXusp@r0tuXus Member Posts: 532 ■■■■□□□□□□
    Why don't you just use a '=SUM("Desktops_Completed", "Laptops_Completed")' formula. That way it updates according to the numbers you have in those corresponding cells.
    Completed: ITIL-F, A+, S+, CCENT, CCNA R|S
    In Progress: Linux+/LPIC-1, Python, Bash
    Upcoming: eJPT, C|EH, CSA+, CCNA-Sec, PA-ACE
Sign In or Register to comment.