 |
 | 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 / February 2007Why #VALUE
My spreadsheet looks something like this: I have 5 columns as shsown below A B C D E DATE Insurance Deposit Rent Total The date goes IN TO A2 iN B2( INSURAnce) I have a formula @if(now()> a2),25,"") IN C2 (DEPOSIT)I have a formula @if(now()> a2),55,"") IN D2 (DEPOSIT)I have a formula @if(now()> a2),45,"") IN E2 I have then formula @sum(b2;d2) the trouble is that when there is not data in col b,c,d 2 the response in e2 is # value why is that thanks > .. when there is no data in col b,c,d 2 > the response in e2 is # value Couldn't replicate your error .. Perhaps try instead in E2: =SUM(B2:D2) [my version uses a colon, not a semicolon] SUM will ignore text, hence if B2:D2 contains null strings: "" E2 would simply return a zero  SignatureMax Singapore http://savefile.com/projects/236895 xdemechanik --- > My spreadsheet looks something like this: > I have 5 columns as shsown below [quoted text clipped - 10 lines] > why is that > thanks ok thanks > > .. when there is no data in col b,c,d 2 > > the response in e2 is # value [quoted text clipped - 20 lines] > > why is that > > thanks welcome SignatureMax Singapore http://savefile.com/projects/236895 xdemechanik --- > ok thanks |
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.