 |
 | 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 / Excel Errors / April 2006#value error
In Cell R6 is N/a R3 is blank. The answer in R7 should return blank and it retruns with #value errorT Here is the formula I am using. I tried different IF and If(ISNA) and still not working justdifferent errors. R6*R$3 which is returning a value of #value. I would like that to return blank thanks > In Cell R6 is N/a R3 is blank. > The answer in R7 should return blank and it [quoted text clipped - 4 lines] > R6*R$3 which is returning a value of #value. > I would like that to return blank Try in R7: =IF(ISERROR(R6*R$3),"",R6*R$3) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- >> In Cell R6 is N/a R3 is blank. >> The answer in R7 should return blank and it [quoted text clipped - 9 lines] >xdemechanik >--- Thanks Much!!!!!!!!!!!!!!!!!Your a life saver!!!!!!!!!!!!!!! >> In Cell R6 is N/a R3 is blank. >> The answer in R7 should return blank and it [quoted text clipped - 9 lines] >xdemechanik >--- Thanks Much!!!!!!!!!!!!!!!!!Your a life saver!!!!!!!!!!!!!!! > Thanks Much!!!!!!!!!!!!!!!!!Your a life saver!!!!!!!!!!!!!!! Glad it worked <g> ! -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
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.