shamimarita's latest activity
-
Hi Shamimarita. Thank you so much. You have been helpful a lot. -
shamimarita replied to the thread [Solved] Tax Calculation.Hello Maps, You are most welcome. Thanks for your feedback and appreciation, it really means a lot to me.
-
shamimarita replied to the thread Number of text cells by color.Hello Dave, First of all, I hope your wife is doing much better now. Please don’t worry about the delayed reply. Thanks for attaching...
-
shamimarita replied to the thread How to distribute Qty equally Among Months in case of change in dates..Hello Pankaj Kumar, You can achieve this with formulas so that both the month headers and the distributed quantities update...
-
shamimarita replied to the thread [Solved] Tax Calculation.Hello Maps, I’m glad the formula is working correctly in Office 365. Since the LET function is not available in older versions of...
-
shamimarita replied to the thread [Solved] Week/Supervisor wise attendance.Hello EmilXmulo, Thank you for your feedback! We’re glad you found the dynamic week setup and the SUMPRODUCT formula useful for...
-
shamimarita replied to the thread Calculation based on lookup values.Hello EmilXmulo, Yes. The received quantity table can contain multiple entries for the same PO#, including partial receipts entered on...
-
shamimarita replied to the thread [Solved] Tax Calculation.Hello Maps, The previous formula calculates the year-to-date rebate from the start of the tax year, so if an employee starts in the...
-
shamimarita replied to the thread Calculation based on lookup values.Hello wiferetire, Thanks for your kind feedback! Yes, the formula will automatically prevent the Outstanding Qty from becoming negative...
-
shamimarita replied to the thread Calculation based on lookup values.Hello Richard03, Yes, exactly. The formula assumes that the received quantity is allocated to duplicate PO# rows from top to bottom...
-
shamimarita replied to the thread nested if statement.Hello Wandy, You can combine Annual Check and Monthly Check using the OR function, since both use the same conditions for the date in...
-
shamimarita replied to the thread Calculation based on lookup values.Hi snowbunny99, You can handle the duplicate PO# rows by allocating the received quantity to each ordered row sequentially instead of...
-
shamimarita replied to the thread Comparing percentage values against constants, less than, greater than, and ranges.Hello bevtyler, Yes, you can simplify this quite a bit instead of continuing with multiple nested IF statements. If the criteria are in...
-
shamimarita replied to the thread Add PassCode requirement for one particular Macro in a Spreadsheet.Hello Almadolam, You can place the column-unhiding commands directly inside the password-protected macro. Try the following code: Sub...
