Variable assumption based fromula

Question

Hi,&nbsp;First time on here, maybe some one can help?&nbsp; I would appreciate some review/feedback and help on the attached images (can send file if necessary) which fails to compute change in salaried employee start date and reduce direct cost from the month they started.&nbsp;I believe all other formulas work correctly but please let me know if there's a better way; formulas I've used:&nbsp;Much appreciated and love you guys.

twifoo · Answer

To enable testing of your formulas, and possible suggestion for improvement, please attach your sample file.

abztahar · Answer

Thanks for your kind review; please see attached&nbsp;Twifoo&nbsp;

twifoo · Answer

In which particular cells of your monthly forecast sheet are you struggling? Please describe the specific results you want to achieve. Perhaps, you can manually enter your desired results, attach your sample file again, then I will analyze which formulas would return those results.

abztahar · Answer

As you can see in assumption boxes; all these variables should perfectly flow into forecast; for example if salaried employee starts in Oct instead then then the forecast should compute its first payment . from Nov &amp; the Direct cost payable also reduces from Nov linking back to the number of jobs that employee can do per week&nbsp;Twifoo&nbsp;&nbsp;&nbsp;

Forum Discussion

Variable assumption based fromula

4 Replies

Resources