Re: Could someone please help me with formulas

From: CLR (croberts_at_tampabay.rr.com)
Date: 02/26/05 

Date: Sat, 26 Feb 2005 11:37:18 -0500

Both of the formulas offered for "H" and all three of the formulas offered
for "I" seem to work for me on XL2k, and according to my understanding of
what you want...........

Could be you're getting caught with the "word wrap" that sometimes occurs
when emailing long formulas..........make sure you're getting the complete
formulas in the cells..........

If you want more help, please give an example of exactly which formula does
not give you what you want.....and be as specific in describing the
deviation as you can..........tks

Vaya con Dios,
Chuck, CABGx3

"No" <no@isp.com> wrote in message
news:112189bp31f8hd3@corp.supernews.com...
> So far nobody has given me a formula for " I " that works, some work but
the
> calculations are wrong..
>
> I'm still trying to figure it out and welcome any help.
>
> "Sandy Mann" <sandymann@mailinator.com> wrote in message
> news:%230KWrYBHFHA.3332@TK2MSFTNGP15.phx.gbl...
> > There is nothing wrong with the answers that you have been given, so
just
> > for the exercise:
> >
> >
> >
=IF(COUNTIF(E2:G2,"Yes")>0,SUM((H2={5,10,20})*((C2-H2)*{0.2,0.3,0.5})),"")
> >
> > Regards
> >
> > Sandy
> > --
> > to e-mail direct replace @mailinator.com with @tiscali.co.uk
> >
> >
> > "No" <no@isp.com> wrote in message
> > news:111vfgeiq9r8l6f@corp.supernews.com...
> > > Because it isn't right to have attachments with posts I have created a
> > > webpage to show what formulas I need help with.
> > > The link is
> > > http://www.eaglepi.com/formula/index.html
> > >
> > > Everything should be clear as to what I need, I have given examples to
> > help
> > > you understand what I am trying to do.
> > >
> > > Thank you in advance
> > >
> > >
> >
> >
>
>