software

Hiya guys and gals

Finaly my project is nearly done!!!!

But i have 1 last problem. My code

=(IF(OR(AND(A18gt;(Current-26),A18lt;=Current),A18gt;Current 26),quot;tquot;,(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: www.excelforum.com/member.php...oamp;userid=29496
View this thread: www.excelforum.com/showthread...hreadid=505564Hi
The only way C18 could be 0, is if the formula is in C18 and the result
if FALSE.
The formula cannot make the values of another cell equal to anything.
It can only return a value to the cell in which it resides, dependant
upon the outcome of the formula.

--
Regards

Roger Govierquot;superkopitequot; gt;
wrote in message
...
gt;
gt; Hiya guys and gals
gt;
gt; Finaly my project is nearly done!!!!
gt;
gt; But i have 1 last problem. My code
gt;
gt; =(IF(OR(AND(A18gt;(Current-26),A18lt;=Current),A18gt;Current 26),quot;tquot;,(C18=0)))
gt;
gt; doesn't work The part highlighted in red is supposed to make c18=0 but
gt; whatever i seem to do i can't seem to get it to work!!
gt;
gt; Please help!!!!!!!!
gt;
gt; Thanks guys
gt;
gt; James
gt;
gt;
gt; --
gt; superkopite
gt; ------------------------------------------------------------------------
gt; superkopite's Profile:
gt; www.excelforum.com/member.php...oamp;userid=29496
gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=505564
gt;

Thanks for clearing that up for me Roger, I'll have to work out another
way round this.

Cheers

James--
superkopite
------------------------------------------------------------------------
superkopite's Profile: www.excelforum.com/member.php...oamp;userid=29496
View this thread: www.excelforum.com/showthread...hreadid=505564Hi

Forgot to mention you need to modify the formula if placing in C18 to
=(IF(OR(AND(A18gt;(Current-26),A18lt;=Current),A18gt;Current 26),quot;tquot;,0)

--
Regards

Roger Govierquot;superkopitequot; gt;
wrote in message
...
gt;
gt; Thanks for clearing that up for me Roger, I'll have to work out
gt; another
gt; way round this.
gt;
gt; Cheers
gt;
gt; James
gt;
gt;
gt; --
gt; superkopite
gt; ------------------------------------------------------------------------
gt; superkopite's Profile:
gt; www.excelforum.com/member.php...oamp;userid=29496
gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=505564
gt;