Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to make a cell value generate a cell value in another cell | Excel Worksheet Functions | |||
leave a cell blank | Excel Worksheet Functions | |||
How do I make a cell equal to another cells value and not it's fo. | Excel Worksheet Functions | |||
conditional formatting blank cell | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |