 |
 | 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 / Worksheet Functions / November 2005what means 'blank cell'??
I am trying to calculate the difference between two dates and have that diveded by seven, (e.g. 7/XX-XX) and remove any answers that sum less than 0.5 So far I have the below formula, but it returns an "ERROR" where there is blank cells. I think that is because of the zero in the ...C3-D3<>0),.. section =IF(AND(ISNUMBER(C3),ISNUMBER(D3),C3-D3<>0),IF(ROUND(7/(C3-D3),5)>0.5,ROUND(7/(C3-D3),5),"")) has anyone any ideas please?? Ted. How about =IF(AND(C3-D3>0,COUNT(C3:D3)=2),IF(ROUND((C3-D3)/7,5)>0.5,ROUND((C3-D3)/7,5),""),"")  SignatureRegards, Peo Sjoblom (No private emails please) >I am trying to calculate the difference between two dates and have that > diveded by seven, (e.g. 7/XX-XX) and remove any answers that sum less than [quoted text clipped - 9 lines] > > Ted. . Oops! reverse the division, I just assumed it was a typo SignatureRegards, Peo Sjoblom (No private emails please) > How about > [quoted text clipped - 13 lines] >> >> Ted. hi, thanks for that - yep that works great $;-D thanks, Ted. > .. > Oops! reverse the division, I just assumed it was a typo [quoted text clipped - 16 lines] > >> > >> Ted. noup, sorry - it gives a blank cell even when the condition it ok (e.g. above 0.5) thanks anyway, Ted. > How about > [quoted text clipped - 13 lines] > > > > Ted. >I am trying to calculate the difference between two dates and have that >diveded by seven, (e.g. 7/XX-XX) and remove any answers that sum less than 0.5 [quoted text clipped - 8 lines] > >Ted. See my response (2nd suggestion) in your other thread. It does not return an error if both cells are blank. It is much easier to obtain coherent help if you keep all your related questions in the same thread. --ron |
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
|
©2009 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.