Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Needing Help Very Bad
Without some sort of explanation how does one know if they are even
qualified to solve the problem? Biff "Mike" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Needing Help Very Bad
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 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Needing Help Very Bad
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(H1 26=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" wrote in message ... 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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Needing Help Very Bad
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 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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Needing Help Very Bad
Well, I'm definitely not one of those psychic types Gord mentioned!
=IF(AND(H126=4001,H128=0%),100%*(H129),IF(AND(H1 26=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" wrote in message ... 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(H1 26=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" wrote in message ... 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 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Needing Help Very Bad
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(H1 26=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" wrote in message ... 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(H1 26=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" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Needing to re-order a datatable display on an Excel chart | Charts and Charting in Excel | |||
Formula for reminder of data needing review on dates? | Excel Worksheet Functions | |||
student needing help w/vlookup function grading criteria | Excel Worksheet Functions | |||
How can I use replace(alt+H) for mutiple items needing replace | Excel Worksheet Functions | |||
Needing to know how to use a "and" in a formula.... | Excel Worksheet Functions |