Needing Help Very Bad

For what I need it would be to hard for me to explain. I have the sheet with
note's in it. Could I maybe E-mail someone to look at

Without some sort of explanation how does one know if they are even
qualified to solve the problem?

Biff

"Mike" <[email protected]> wrote in message
news:[email protected]...
> For what I need it would be to hard for me to explain. I have the sheet
> with
> note's in it. Could I maybe E-mail someone to look at

Give the explanation a try Mike.

You'd be surprised at the psychic abilities of some of the regulars around here.


Gord Dibben MS Excel MVP

On Tue, 18 Jul 2006 18:22:01 -0700, Mike <[email protected]> wrote:

>For what I need it would be to hard for me to explain. I have the sheet with
>note's in it. Could I maybe E-mail someone to look at

Because your the Biff LOL

I got most of it figured out. Having one problem with this formula
=IF(AND(H126>=4001,H128>=0%),100%*(H129),IF(AND(H126>=3251,H126<=4000,H128>=5%),50%*(H129),0))

I need only the 5% to return a absolute value of 5%. Can you help
"Biff" wrote:

> Without some sort of explanation how does one know if they are even
> qualified to solve the problem?
>
> Biff
>
> "Mike" <[email protected]> wrote in message
> news:[email protected]...
> > For what I need it would be to hard for me to explain. I have the sheet
> > with
> > note's in it. Could I maybe E-mail someone to look at
>
>
>

Look at My reply to biff

"Gord Dibben" wrote:

> Give the explanation a try Mike.
>
> You'd be surprised at the psychic abilities of some of the regulars around here.
>
>
> Gord Dibben MS Excel MVP
>
> On Tue, 18 Jul 2006 18:22:01 -0700, Mike <[email protected]> wrote:
>
> >For what I need it would be to hard for me to explain. I have the sheet with
> >note's in it. Could I maybe E-mail someone to look at
>
>

Well, I'm definitely not one of those psychic types Gord mentioned!

> =IF(AND(H126>=4001,H128>=0%),100%*(H129),IF(AND(H126>=3251,H126<=4000,H128>=5%),50%*(H129),0))
>
> I need only the 5% to return a absolute value of 5%

I don't understand!

You don't need the ( ) around H129.

Biff

"Mike" <[email protected]> wrote in message
news:[email protected]...
> Because your the Biff LOL
>
> I got most of it figured out. Having one problem with this formula
> =IF(AND(H126>=4001,H128>=0%),100%*(H129),IF(AND(H126>=3251,H126<=4000,H128>=5%),50%*(H129),0))
>
> I need only the 5% to return a absolute value of 5%. Can you help
> "Biff" wrote:
>
>> Without some sort of explanation how does one know if they are even
>> qualified to solve the problem?
>>
>> Biff
>>
>> "Mike" <[email protected]> wrote in message
>> news:[email protected]...
>> > For what I need it would be to hard for me to explain. I have the sheet
>> > with
>> > note's in it. Could I maybe E-mail someone to look at
>>
>>
>>

Do you mean ..

ABS(H128)>=5% ???

=IF(AND(H126>=4001,H128>=0%),100%*H129,IF(AND(H126>=3251,H126<=4000,ABS(H128)>=5%),50%*H129,0))


"Biff" wrote:

> Well, I'm definitely not one of those psychic types Gord mentioned!
>
> > =IF(AND(H126>=4001,H128>=0%),100%*(H129),IF(AND(H126>=3251,H126<=4000,H128>=5%),50%*(H129),0))
> >
> > I need only the 5% to return a absolute value of 5%
>
> I don't understand!
>
> You don't need the ( ) around H129.
>
> Biff
>
> "Mike" <[email protected]> wrote in message
> news:[email protected]...
> > Because your the Biff LOL
> >
> > I got most of it figured out. Having one problem with this formula
> > =IF(AND(H126>=4001,H128>=0%),100%*(H129),IF(AND(H126>=3251,H126<=4000,H128>=5%),50%*(H129),0))
> >
> > I need only the 5% to return a absolute value of 5%. Can you help
> > "Biff" wrote:
> >
> >> Without some sort of explanation how does one know if they are even
> >> qualified to solve the problem?
> >>
> >> Biff
> >>
> >> "Mike" <[email protected]> wrote in message
> >> news:[email protected]...
> >> > For what I need it would be to hard for me to explain. I have the sheet
> >> > with
> >> > note's in it. Could I maybe E-mail someone to look at
> >>
> >>
> >>
>
>
>