₦airaland Forum

Welcome, Guest: 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 - Programming - Nairaland

Nairaland Forum / Science/Technology / Programming / Need Help With Excel Function (271 Views)

Any One Good With Excel Here I Have A Job For You / Contest[closed] : Program A Function to find if a phrase. is in a string / SHA1 Function Is Now Dead (2) (3) (4)

(1) (Reply)

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 ".)

1 Like

Re: Need Help With Excel Function by jmaxjohn(m): 8:49am On Aug 13
airsaylongcon:
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 ".)

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)

Web Developers Secret Exposed!!! Anybody Can Now Build Website...see Why.. / I Want To Buy A Verified Adsense Account, Who's Selling? / Hackers Did You Have An Idea Of Facebook Phising In The Past?

(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: (0) (1) (2) (3) (4) (5) (6) (7) (8) (9)

Nairaland - Copyright © 2005 - 2019 Oluwaseun Osewa. All rights reserved. See How To Advertise. 19
Disclaimer: Every Nairaland member is solely responsible for anything that he/she posts or uploads on Nairaland.