Hey guys, I need a IF Statement (I think) to determine the Open Menus (E5). Using B5, D5 and F5. If the one of the cells from column A in the sheet "Formula Ref. is typed in D5 then the # of covers in B5 goes to E5, then F5 would contain either a yes or no and if it is yes, then it will return E5 to 0, if it is no, then it will stay the same. Let me know if this makes sense. Or if even possible... Thanks all!
Hi,
Its not clear how this works.
What happens when D5 does contain a time from column A of the Formula Ref sheet and the B5 value goes into E5. What then?
You say F5 should be a Yes or No, but which?
Are you saying that when E5 is populated with the B5 value then F5 becomes a No, but then if F5 is subsequently changed to Yes, then E5 is set back to zero? This could be controlled by a small SheetSelection_Change event macro but I need to understand exactly what you expect to see and when.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Edit::
Hi, thanks for taking some time to help!
So the basic gist is...
The covers, table, time seated, and ordered will be manually put in. I don't want to have to touch the open menu column. So here goes,
Once the guest "B5" shows up nothing happens. We just type in how many guests there are. But, when we type in what time they are officially seated in "D5" that is generated from the value of times in the Formula Ref. Sheet in column A then the cover number "B5" pulls to the open menus "E5". Then if we type no in the ordered column "F5" then nothing changes, but if we type yes, then the number in "E5" goes to 0.
Does this make sense? This is probably a terrible way of explaining it. But just let me know! Thank you!!!
I guess a better way to explain would be...
If D5 = any values from the Formula Ref Sheet A1:A22 then E5=B5 and if F5 = Yes then E5 = 0
Does that help?
Bump Please
Administrative Note:
We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not told us about this. You are required to do so.
Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.
(Note: this requirement is not optional. No help to be offered until you provide a link or, for members with fewer than 10 posts, a comment telling us where else you have posted this query.)
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Try
=IF($F5="Yes",0,IFERROR(IF(MATCH($D5,'Formula Ref.'!$A$1:$A$22,0),$B5,""),""))
or
=IF($F5="Yes",0,IFERROR(IF(MATCH($D5,'Formula Ref.'!$A$1:$A$22,0),$B5,""),0))
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Thank you! Works amazing.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks