#Value! Assistance

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: bj (anonymous_at_discussions.microsoft.com)
Date: 08/26/04 

Date: Thu, 26 Aug 2004 12:50:43 -0700

try
=if(B2<>"",M2/0.003472222*5,"")
>-----Original Message-----
>What I'd like to do is eliminate this error in the
resulting cell's when
>there may be no data in the cells involved in the
calculations. As it stands
>currently as long as cell B2 and M2 cantain data, I'm
okay. However, if this
>cell's do not contain data, then I end up with the
dreaded #Value! error.
>Below is a sample of what I currently have:
>
>=IF(B2<>"",M2," ")/0.003472222*5
>
>Any asitance with the formula above will be appreciated.
>
>Thanks,
>.
>

Relevant Pages

  • Re: Finding the most recent months (or whatever) data
    ... How about just designating 2 cells where you enter a starting date and ... ending date for your calculations? ... Try this to average closing if closing was in Column E and dates are in ... Okay, I've made a good bit of progress (have also been reading ...
    (microsoft.public.excel.misc)
  • Re: #Value! Assistance
    ... HTH ... >there may be no data in the cells involved in the ... calculations. ... >Any asitance with the formula above will be appreciated. ...
    (microsoft.public.excel.worksheet.functions)
  • #Value! Assistance
    ... there may be no data in the cells involved in the calculations. ... currently as long as cell B2 and M2 cantain data, I'm okay. ... Any asitance with the formula above will be appreciated. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Document with multiple tables, form fields, bookmarks and calc
    ... the final calculations showing the error message and the formula causing them. ... into each of the cells in that row: ... While it is possible to create such a form using form fields, ... recommend that it be done with a userform. ...
    (microsoft.public.word.tables)
  • Re: Modelling 30 years monthly across sheets
    ... > I have been asked to model cashflows for a company for 30 years ... > monthly (i.e. 360 data calculation cells). ... > is not enough for the calculations. ... I feel my only option is to use two sheets (or two ...
    (microsoft.public.excel.misc)