 |
 | 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 / October 2006Formula Error
Hey everyone. Thhis formuls works ok but I just noticed that it will still leave a % in the destination cell (L13) even when one or more entries are made into the cellsAI13, AW13, BI13, BW13, CJ13 ie: I don't want anything to appear in L13 unless all of the cells mentioned have a value in them. Chers David Roger if your out there HELP! =IF(OR(AI13="N",AW13="N",BI13="N",BW13="N",CJ13="N",AI13="R",AW13="R",BI13="R",BW13="R",CJ13="R"),"",SUM(AI13/100+AW13/100+BI13/100+BW13/100+CJ13/100)/5) =IF(OR(AI13="", AW13="", BI13="", BW13="", CJ13=""),"", your formula) Regards Trevor > Hey everyone. > [quoted text clipped - 10 lines] > > =IF(OR(AI13="N",AW13="N",BI13="N",BW13="N",CJ13="N",AI13="R",AW13="R",BI13="R",BW13="R",CJ13="R"),"",SUM(AI13/100+AW13/100+BI13/100+BW13/100+CJ13/100)/5) Trevor, thanks for the help, however when I placed your formula at the begining of mine I couldn,t get out of error window that kept popping up....I've done something wrong but I have no idea what? Cheers David > =IF(OR(AI13="", AW13="", BI13="", BW13="", CJ13=""),"", your formula) > [quoted text clipped - 16 lines] > > > > =IF(OR(AI13="N",AW13="N",BI13="N",BW13="N",CJ13="N",AI13="R",AW13="R",BI13="R",BW13="R",CJ13="R"),"",SUM(AI13/100+AW13/100+BI13/100+BW13/100+CJ13/100)/5) I give in; it should look like this: =IF(OR(AI13="", AW13="", BI13="", BW13="", CJ13=""),"", IF(OR(AI13="N",AW13="N",BI13="N",BW13="N",CJ13="N",AI13="R",AW13="R",BI13="R",BW13="R",CJ13="R"),"",SUM(AI13/100+AW13/100+BI13/100+BW13/100+CJ13/100)/5)) Note: you need to lose the "=" sign from the beginning of your formula. Could that be the problem ? Regards Trevor > =IF(OR(AI13="", AW13="", BI13="", BW13="", CJ13=""),"", your formula) > [quoted text clipped - 17 lines] >> >> =IF(OR(AI13="N",AW13="N",BI13="N",BW13="N",CJ13="N",AI13="R",AW13="R",BI13="R",BW13="R",CJ13="R"),"",SUM(AI13/100+AW13/100+BI13/100+BW13/100+CJ13/100)/5)
|
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.