Re: Could someone please help me with formulas

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Dana DeLouis (delouis_at_bellsouth.net)
Date: 02/26/05 

Date: Sat, 26 Feb 2005 11:38:13 -0500

I think there are better ways, but here is one quick and dirty option.

H1 ->
      =SUMPRODUCT(--(E1:G1="yes"),{5,10,20})

      I1->
      =(C1-SUMPRODUCT( --(E1:G1="yes"),{5,10,20})) *
SUMPRODUCT( --(E1:G1="yes"),{0.2,0.3,0.5})

Perhaps use Data Validation to make sure you have at most one "yes" in
E1:G1.
HTH 

-- 
Dana DeLouis
Win XP & Office 2003
"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
>> >
>> >
>>
>>
>
>