Entering Formula in VB

NoSparks · #1 08-31-2018, 09:38 PM

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

Khwaja · #2 09-01-2018, 12:19 AM

Thank you so much for your help.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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