Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 06-06-2023, 10:39 PM
redirected_math redirected_math is offline more than 64 level nesting Windows 10 more than 64 level nesting Office 2019
Novice
more than 64 level nesting
 
Join Date: Jun 2023
Posts: 1
redirected_math is on a distinguished road
Default more than 64 level nesting

hi,


here is the situation. in "sample 1" file i need to change date and shift based on previous cell date. currently i managed to if A3 has date "DATE: 06/06/2023" then A20 will be "DATE: 06/06/2023" and if a3 has date "DATE: 06/06/2023" then A20 will be "DATE: 07/06/2023" and so on. it depends on "shift" as you can see i have to check it manually if there is production in both shifts of the day. if not i have to hide the entire row of page of that shift. if suddenly no production on a given date i change in manually then rest the dates goes following that date. shift formula and date formula is separated in sample 1 A20, A21 and so on.


And shift cell A21 is simple, if A4 is "SHIFT : A" then A21 is "SHIFT : B" & A4 is "SHIFT : B" then A21 is "SHIFT : A".




here is what i want to do-

if A3 has date "DATE: 06/06/2023" & A4 is "SHIFT : A" then A20 will be "DATE: 06/06/2023" because A20 page is the same day but different shift.


if A3 has date "DATE: 06/06/2023" & A4 is "SHIFT : B" then A20 will be "DATE: 07/06/2023" because its the next day another shift.


now i want to combine this functions. so i tried the formula in "tried formula.docx".


it gives "more than 64 level nesting" error while i paste it.


please help me. i tried best i could to explain. please use the excel file to understand the situation more.
Attached Files
File Type: xlsx sample 1.xlsx (178.0 KB, 12 views)
File Type: docx tried formula.docx (12.7 KB, 5 views)

Last edited by redirected_math; 06-06-2023 at 10:44 PM. Reason: simplified the attatchment (tried formula.docx)
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
INDEX and MATCH nesting with if Peter Simpson Excel Programming 1 05-27-2019 06:53 AM
more than 64 level nesting Nesting Merge Fields LearningMom Mail Merge 9 09-25-2017 01:44 PM
more than 64 level nesting Automatic numbered lists - Cannot create new point at level 2, after making level 3 points. icor1031 Word 1 01-14-2016 09:24 PM
Nesting and IF & AND statement lynchbro Excel 4 04-16-2015 11:39 AM
more than 64 level nesting Nesting Variables SET, LISTNUM, and REF Wyskers Word 1 11-13-2011 05:43 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:35 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft