Entering Formula in VB

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Entering Formula in VB

FAQ

Thread Tools

Display Modes

08-31-2018, 09:38 PM

NoSparks

Windows 7 64bit Entering Formula in VB

Office 2010 64bit

Excel Hobbyist

Join Date: Nov 2013

Location: British Columbia, Canada

Posts: 842

Try

Code:

Range("K3").Formula = "=IF(H2="""","""",IF(AND(H2>TIMEVALUE(""5:00""),E2<TIMEVALUE(""9:00 AM"")),""10:00 AM"", IF(AND(H2>TIMEVALUE(""5:00""),E2>TIMEVALUE(""9:00 AM"")),""12:00 PM"","""")))"

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Entering a column value in a cell, to be used as part of a reference in a formula in another cell	paulkaye	Excel	4	02-26-2017 04:18 AM
entering name in outlook does not autofill	Franksplace2	Word	0	03-08-2015 04:10 PM
entering duration in months	ketanco	Project	1	12-17-2014 01:09 PM
entering lump sum costs	ketanco	Project	1	12-24-2011 12:56 PM
Entering Contact details	GemmaD	Outlook	0	12-18-2008 06:41 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:41 AM.