Needing Help Very Bad

M

Mike

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
 
B

Biff

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

Biff
 
G

Gord Dibben

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
 
M

Mike

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
 
M

Mike

Look at My reply to biff

Gord Dibben said:
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
Click to expand...
 
B

Biff

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%
Click to expand...

I don't understand!

You don't need the ( ) around H129.

Biff
 
T

Toppers

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))
 
Top