make Cell blank
 

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),A18Current+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...o&userid=29496
View this thread: http://www.excelforum.com/showthread...hreadid=505564

make Cell blank
 

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"
wrote in message
...

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),A18Current+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...o&userid=29496
View this thread:
http://www.excelforum.com/showthread...hreadid=505564

make Cell blank
 

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

Cheers

James


--
superkopite
------------------------------------------------------------------------
superkopite's Profile: http://www.excelforum.com/member.php...o&userid=29496
View this thread: http://www.excelforum.com/showthread...hreadid=505564

make Cell blank
 

Hi

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

--
Regards

Roger Govier


"superkopite"
wrote in message
...

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

Cheers

James


--
superkopite
------------------------------------------------------------------------
superkopite's Profile:
http://www.excelforum.com/member.php...o&userid=29496
View this thread:
http://www.excelforum.com/showthread...hreadid=505564