Hello,
I need help creating a formula please. The attached spreadsheet shows a daily rate, a days per week worked and the number of days available each week, taking stat holidays and the org closed days into account. What I need is an IF formula which looks at column C, and if it reads '5', then returns the value in row 2 for that column. If column C reads less than 5, then I need it to then look at row 2, and compare it to the value in column C - if the value in column C is lower, thenit should return the value of C, if the value of column C is higher, then it should return the value in row 2.
An example is if someone works 5 days a week, then I want whatever is in row 2 returned, which is the maximum n umbner of days possible. But, as in C4, where someone works 2 days a week - I want 2 to be returned in every cell (D4:DC4) where the total days available is at least 2. But, where there are 0 days available, I need it to return 0.
Help very much appreicated!
Kind regards,
Fiona
I need help creating a formula please. The attached spreadsheet shows a daily rate, a days per week worked and the number of days available each week, taking stat holidays and the org closed days into account. What I need is an IF formula which looks at column C, and if it reads '5', then returns the value in row 2 for that column. If column C reads less than 5, then I need it to then look at row 2, and compare it to the value in column C - if the value in column C is lower, thenit should return the value of C, if the value of column C is higher, then it should return the value in row 2.
An example is if someone works 5 days a week, then I want whatever is in row 2 returned, which is the maximum n umbner of days possible. But, as in C4, where someone works 2 days a week - I want 2 to be returned in every cell (D4:DC4) where the total days available is at least 2. But, where there are 0 days available, I need it to return 0.
Help very much appreicated!
Kind regards,
Fiona