|Join Nairaland / LOGIN! / Trending / Recent / New|
Stats: 2,317,740 members, 5,108,932 topics. Date: Wednesday, 21 August 2019 at 11:48 PM
|Need Help With Excel Function by jmaxjohn(m): 6:00am On Aug 06|
I am struggling mightily on a spreadsheet , please i'd appreciate all of your help. So here's what i need.
1. I need a range of cells (say B) to show dates, specifically every Monday, Tuesday, Thursday and Friday of the month (next 2 months in fact).
2. If B2 is, say a Monday, then cell C2 should show the time 12:00pm. The idea is to have all cells under C give the value of 12:00pm for Mondays, Tuesdays, and Thursdays, while 02:00pm for Fridays of the month.
Excel and Programming gurus should please come to my rescue. Please help me with a formulas that can solve this
|Re: Need Help With Excel Function by airsaylongcon: 6:53pm On Aug 07|
Will cell B2 ever hold values other than Monday, Tuesday, Thursday or Friday?
If No then in C2, type
=IF(B2<>"Thursday", "12:00pm","2:00pm" )
(delete the space between the closing parenthesis and the ".)
|Re: Need Help With Excel Function by jmaxjohn(m): 8:49am On Aug 13|
mehn, just seeing this. thanks a million for the reply. i sorted out number 1 on my list, thanks for sorting out number 2. now lemee try it
|Sections: politics (1) business autos (1) jobs (1) career education (1) romance computers phones travel sports fashion health |
religion celebs tv-movies music-radio literature webmasters programming techmarket
Nairaland - Copyright © 2005 - 2019 Oluwaseun Osewa. All rights reserved. See How To Advertise. 19