make Cell blank

[superkopite]

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

 

[Roger Govier]

Hi
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 Govier


"superkopite" <[email protected]>
wrote in message
news:[email protected]...

 

[superkopite]

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

Cheers

James

 

[Roger Govier]

Hi

Forgot to mention you need to modify the formula if placing in C18 to
=(IF(OR(AND(A18>(Current-26),A18<=Current),A18>Current+26),"t",0)

--
Regards

Roger Govier


"superkopite" <[email protected]>
wrote in message
news:[email protected]...