Forum Discussion
=IF Formula - The statement value is not stored as a number.
There may be many ways to address this. If you could attach a sample document without sensitive data we may be able to share a more accurate solution depending on the structure of your document. However, as a quick solution;
Would it be possible for you to use:
=IF(A1=6,SUM(B1:B5)+90,SUM(B1:B5))
Being A1 the cell indicating how many days an employee works and range B1:B5 the range you want to apply the SUM function. I believe you may save an unnecessary step with this solution.
There may be many ways to address this. If you could attach a sample document without sensitive data we may be able to share a more accurate solution depending on the structure of your document. However, as a quick solution;
Would it be possible for you to use:
=IF(A1=6,SUM(B1:B5)+90,SUM(B1:B5))
Being A1 the cell indicating how many days an employee works and range B1:B5 the range you want to apply the SUM function. I believe you may save an unnecessary step with this solution.
MAngosto Thank you so much much! I have played around this this formula to suit and it has worked!