Home

Variable assumption based fromula

%3CLINGO-SUB%20id%3D%22lingo-sub-733655%22%20slang%3D%22en-US%22%3EVariable%20assumption%20based%20fromula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-733655%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFirst%20time%20on%20here%2C%20maybe%20some%20one%20can%20help%3F%26nbsp%3B%20I%20would%20appreciate%20some%20review%2Ffeedback%20and%20help%20on%20the%20attached%20images%20(can%20send%20file%20if%20necessary)%20which%20fails%20to%20compute%20change%20in%20salaried%20employee%20start%20date%20and%20reduce%20direct%20cost%20from%20the%20month%20they%20started.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20believe%20all%20other%20formulas%20work%20correctly%20but%20please%20let%20me%20know%20if%20there's%20a%20better%20way%3B%20formulas%20I've%20used%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMuch%20appreciated%20and%20love%20you%20guys.%3C%2FP%3E%3CP%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F121855i3E36A76D227355B7%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Formulas%20used.png%22%20title%3D%22Formulas%20used.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-733655%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-733738%22%20slang%3D%22en-US%22%3ERe%3A%20Variable%20assumption%20based%20fromula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-733738%22%20slang%3D%22en-US%22%3E%3CP%3EAs%20you%20can%20see%20in%20assumption%20boxes%3B%20all%20these%20variables%20should%20perfectly%20flow%20into%20forecast%3B%20for%20example%20if%20salaried%20employee%20starts%20in%20Oct%20instead%20then%20then%20the%20forecast%20should%20compute%20its%20first%20payment%20.%20from%20Nov%20%26amp%3B%20the%20Direct%20cost%20payable%20also%20reduces%20from%20Nov%20linking%20back%20to%20the%20number%20of%20jobs%20that%20employee%20can%20do%20per%20week%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F280482%22%20target%3D%22_blank%22%3E%40Twifoo%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-733729%22%20slang%3D%22en-US%22%3ERe%3A%20Variable%20assumption%20based%20fromula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-733729%22%20slang%3D%22en-US%22%3EIn%20which%20particular%20cells%20of%20your%20monthly%20forecast%20sheet%20are%20you%20struggling%3F%20Please%20describe%20the%20specific%20results%20you%20want%20to%20achieve.%20Perhaps%2C%20you%20can%20manually%20enter%20your%20desired%20results%2C%20attach%20your%20sample%20file%20again%2C%20then%20I%20will%20analyze%20which%20formulas%20would%20return%20those%20results.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-733707%22%20slang%3D%22en-US%22%3ERe%3A%20Variable%20assumption%20based%20fromula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-733707%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20for%20your%20kind%20review%3B%20please%20see%20attached%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F280482%22%20target%3D%22_blank%22%3E%40Twifoo%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-733682%22%20slang%3D%22en-US%22%3ERe%3A%20Variable%20assumption%20based%20fromula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-733682%22%20slang%3D%22en-US%22%3ETo%20enable%20testing%20of%20your%20formulas%2C%20and%20possible%20suggestion%20for%20improvement%2C%20please%20attach%20your%20sample%20file.%3C%2FLINGO-BODY%3E
abztahar
New Contributor

Hi,

 

First time on here, maybe some one can help?  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.

 

I believe all other formulas work correctly but please let me know if there's a better way; formulas I've used:

 

Much appreciated and love you guys.


Formulas used.png

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

Thanks for your kind review; please see attached @Twifoo 

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.

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 & the Direct cost payable also reduces from Nov linking back to the number of jobs that employee can do per week @Twifoo