 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / July 2006Make a cell blank given a code
I am trying to achieve a blank cell which currently has a formula relating to a different sheet. On sheet named "week" In cell M32 I have the following code =IF(OR(D33>0,G33>0),'Stats-Job'!M9,) However if the code M is in another cell, at say H32, then I want the cell M32 to remain blank, Any help appreciated. Mel just wrap in another if =if(h32="M","", yourformula)  SignatureDon Guillett SalesAid Software dguillett1@austin.rr.com >I am trying to achieve a blank cell which currently has a formula relating >to a different sheet. [quoted text clipped - 11 lines] > > Mel Hi Don, and thanks, I've tried this =IF(H32="M","",IF(OR(D33>0,G33>0),'Stats-Job'!M9,)) but now if there is no "M" in the cell it gives me a "ref" error?/ Mel > just wrap in another if > =if(h32="M","", yourformula) [quoted text clipped - 14 lines] >> >> Mel =IF(OR(h32="M",D33<=0,G33<=0),"",'Stats-Job'!M9) SignatureDon Guillett SalesAid Software dguillett1@austin.rr.com > Hi Don, and thanks, I've tried this > [quoted text clipped - 21 lines] >>> >>> Mel try this =IF(OR(h32<>"m",D33>0,G33>0),'Stats-Job'!M9,"") SignatureDon Guillett SalesAid Software dguillett1@austin.rr.com > just wrap in another if > =if(h32="M","", yourformula) [quoted text clipped - 14 lines] >> >> Mel Don, Many thanks for your help, =IF(H32="M","",IF(OR(D33>0,G33>0),'Stats-Job'!M9,)) Which is what you were trying to tell me in your first post, I got the spelling wrong on my reference to the other sheet, too long out of bed and fingers cold and typed the wrong sheet name, I thank you very much for helping me. Bed time in eastern Australia. Mel > try this > [quoted text clipped - 18 lines] >>> >>> Mel BTW, I have tried this but it gives me a value error =IF(OR(D33>0,G33>0),'Stats-Job'!M9,)*IF(H32="M","") Its after midnight here in Melbourne Australia, but I'm still up working. I would appreciate anyone who knows how I fix this problem. I may need to go to bed soon but thank anyone who can help and will look in the morning. Thank you >I am trying to achieve a blank cell which currently has a formula relating >to a different sheet. [quoted text clipped - 11 lines] > > Mel
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.