Need Help With Excel Function - Programming - Nairaland
Nairaland Forum / Science/Technology / Programming / Need Help With Excel Function (927 Views)
In Need Of Someone Who Is Good With Excel / Can This Be Possible With Excel? / Brain Teaser: Recursive Anonymous Function Expression Analysis (2) (3) (4)
(1) (Reply)
| Need Help With Excel Function by jmaxjohn(m): 6:00am On Aug 06, 2019 |
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, 2019 |
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 ".) 1 Like |
| Re: Need Help With Excel Function by jmaxjohn(m): 8:49am On Aug 13, 2019 |
airsaylongcon: 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 |
(1) (Reply)
Basic Programming Materials / What Is The Programmin Langauge Used In Mobile Ntwk? / New Software Firm
(Go Up)
| 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 Links: (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) Nairaland - Copyright © 2005 - 2024 Oluwaseun Osewa. All rights reserved. See How To Advertise. 7 |