Excel sharepoint formula
Hi, I need assistance with the “Bandwidth” tab, specifically cells B2
. In the “Raw Data” tab, if an employee’s name appears in column C, the formula for B2 should be 1 minus the sum of values in column D for that employee. For example, if Jeff has values 0.20 and 0.45 in the “Raw Data” tab, then in the “Bandwidth” tab, B2 should be calculated as 1 minus 0.20 plus 0.45.
https://ceridian.sharepoint.com/:x:/r/teams/MAUPayrollProject/_layouts/15/Doc.aspx?sourcedoc=%7B7af44531-abf9-49db-8450-d3b88165af8f%7D&action=edit&wdPreviousSession=47b9aa35-8172-d667-505d-c2e9b89d566d Hi, I need assistance with the “Bandwidth” tab, specifically cells B2. In the “Raw Data” tab, if an employee’s name appears in column C, the formula for B2 should be 1 minus the sum of values in column D for that employee. For example, if Jeff has values 0.20 and 0.45 in the “Raw Data” tab, then in the “Bandwidth” tab, B2 should be calculated as 1 minus 0.20 plus 0.45. Read More