Posted to microsoft.public.excel.programming

external usenet poster

Posts: 7

if & and code problem

I have spent hours trying to correct this Excel code and am considering
resigning.
Can anyone help ?

ActiveCell.Formula =
"=IF((C2)="""",""1"",IF(AND((A2)=""enddate"",(E2)< ""01/01/01"",(E2)<NOW()+14),""2"",if(and((A2)=""startem"", date(0,month(e2),day(e2))date(0,month(now()),day( now())),(e2)=""3""),""XXX""))"

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
If/then code problem	peter.thompson[_12_]	Excel Programming	2	December 27th 05 03:19 AM
Can anyone see the problem with this code?	Cody	Excel Programming	5	July 21st 05 11:23 PM
code problem	scrabtree23[_2_]	Excel Programming	2	September 16th 04 05:28 AM
Problem with this code	Jonsson[_8_]	Excel Programming	2	April 21st 04 01:07 PM
Code problem	Rick[_11_]	Excel Programming	1	August 8th 03 04:25 AM

All times are GMT +1. The time now is 11:39 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us