LinkBack URL
About LinkBacks
How can I get the results in cell J11 to output into cells G11 or H11, depending on whether cell B11 is either Sat or Sun.
Any help will be greatly appreciated.
How can I get the results in cell J11 to output into cells G11 or H11, depending on whether cell B11 is either Sat or Sun.
Any help will be greatly appreciated.
......................
Using your sample workbook, see attached....formulas are in column G & H
need-to-have-reuslts-in-different-cells-depending-on-which-day-book2.xlsx
Edit* The workbook wont open for me when I click the link, not sure if it's the same for anyone else, but, I did what newdoverman posted.
Last edited by gmr4evr1; 09-20-2015 at 11:56 AM. Reason: Added edit
1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.
Tom
Enter in G11 and fill down:
Formula:
=IF(B11="Sat",J11,"")
Enter in H11 and fill down:
Formula:=IF(B11="Sun",J11,"")
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Thanks gmr4evr1 and newdoverman; for you very speedy responses, not sure why the example wouldn't open. Anyway, I tried your very efficient and simple fixes, which worked great, however, I should have explained that if the results were under the Sat /Sun column, then nothing should appear in the Weekday column.
Any thoughts?
Change G11 to the following and fill down:
Formula:=IF(B11="Sat",IF($M11=7.5," ",IF(F11=8,7.5,IF($F11=12,11.25))),"")
Change H11 to the following and fill down:
Formula:=IF(B11="Sun",IF($M11=7.5," ",IF(F11=8,7.5,IF($F11=12,11.25))),"")
Change J11 to the following and fill down:
Formula:=IF(OR(B11="Sat",B11="Sun"),"",IF($M11=7.5," ",IF(F11=8,7.5,IF($F11=12,11.25))))
Dang it! It took me a bit longer to figure it out, but here is my solution..
Put this in G11 and drag down
This in H11 and drag down
=IF(B11<>"Sat"," ",IF(F11=8,7.5,IF($F11=12,11.25,"")))
This in J11 and drag down=IF(B11<>"Sun"," ",IF(F11=8,7.5,IF($F11=12,11.25,"")))
=IF(B11="Sat","",IF(B11="Sun","",IF($M11=7.5," ",IF(F11=8,7.5,IF($F11=12,11.25,"")))))
Thanks again to newdoverman, and gmr4evr1. You have both come up with the goods.Thanks to you, this will make filing in my wifes hospital timesheet a breeze.
Cheers fellas.
Thank you for the feedback.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
You're welcome, glad it worked for you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks