make Cell blank

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance




Hiya guys and gals

Finaly my project is nearly done!!!!

But i have 1 last problem. My code

=(IF(OR(AND(A18>(Current-26),A18<=Current),A18>Current+26),"t",(C18=0)))

doesn't work The part highlighted in red is supposed to make c18=0 but
whatever i seem to do i can't seem to get it to work!!

Please help!!!!!!!!

Thanks guys

James


--
superkopite
------------------------------------------------------------------------
superkopite's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29496
View this thread: http://www.excelforum.com/showthread.php?threadid=505564

.



Relevant Pages

  • Re: Non printing rows
    ... > Hiya Guys and gals ... in all rows there is somekind of forumla. ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • Add to Formula
    ... Hiya Guys and Gals ... I am a little stuck but think that i am seeing the light! ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • How to add OR statement
    ... Hiya guys and gals ... superkopite's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29496 ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • Re: lalalalal...Air pressure
    ... Hey guys - gals! ... UNtoldfox's Profile: http://www.unicyclist.com/profile/10432 ... Prev by Date: ...
    (rec.sport.unicycling)
  • Re: Im Baaaaaack....
    ... Hiya! ... Joel ... Joel344's Profile: http://dentalcom.net/forum/member.php?userid=12 ... Prev by Date: ...
    (sci.med.dentistry)