Nice one Thomas...
Posts by katie1071


Thank you Will. I had my ( wrong. That's my BIGGEST problem.
Thanks again!
KT 
Hello,
I am trying to combine 2 statements and am having difficulties. I'm trying to use an IF statement, but there are more than one factors to produce true or false:
I am calculating 10% of a number and need to set a minimum and maximum level on the 10%. If 10% of the value is less than 8, then equal 8 and IF 10% of the value is greater than 80, then equal 80. Otherwise equal 10% of the value.
Thanks for your help.
Kt 
Brilliant! I just changed the & to IF and made a small adjustment and this serves my purpose VERY NICELY!
Thank you SO much for your help!
:kiss:
Katie 
Yeah, it's Greenville Ave, tons of bars...pretty fun.
I'm having a problem joining 2 formulas together. Probably something goofy with my ()'s.
:cheers:

Rennie
Take a look at the attachment now. I just can't seem to join the 2 formulas together. I am probably doing something stupid with the (), but this is driving me insane!

Austin is pretty cool. Houston is ugly. But Dallas is the spot...that's where I am.
Since you're online, you want to take a stab at a formula problem?

Quote
Originally posted by noeyedeer
Didn't think the Net had reached most of Texas yet !!? :coolwink:That's just not right...we're not all hicks!
:duh: 
Quote
Originally posted by XLDennis
..and some lost swedish XLusers as well from other countries around our beatiful world :coolwink:
I have noticed most of the users I've seen are on your side of the pond. I'm sure I'm not the first Texan...:coolwink:

Rennie
You have at least proven to me that the formula can handle the logic I am trying to accomplish...I guess my biggest issue is getting the dates down correctly. I want each month's formula to work independently.
I'll try and come up with a better explanation if I can.
Thanks for your help!Paddyd
Good info, but the pricing isn't the issue, it's each cell that represents a date/month/year knowing when to do what.Katie:D

Had to look that one up!
Thanks again!

Thank you so much!
Lots of Aussies on this board!
Katie :wink1:

Every time I copy a date from one file to another, it adds 1 day & 4 years to the date.
Does anyone know a fix for this?
Thanks!
Katie 
Well,
I've fudged somewhere and my second formula isn't working now!Take a look at my attachment and maybe you can help with that as well.
Thanks!
katie 
Hi FWind,
I'm new to the board. Can you tell me how to post the file?Thanks,
Katie 
Does anyone have a lot of expertise in nestling formulas? I have 2 formulas that I have tested independent of each other, but can't seem to get them to work in conjunction with each other.
Thanks!
Katie 
Yeah, me too! It seems my needs are not very general. I'm not positive what you requested, but maybe this explanation may help?
The formula is used in a form of pricing that is spread out over 12 months and not just 1 flat price.
So let's say I charge you $12,000 per year for product X, but I'm going to break it out into 12 months. Now, I have 12 months broken out and each cell equals $1000. Then, 6 months later you want to add 1 more X item at $12,000. I need to add the $1000 price starting at the 6th month and ending at the last month. I have the first 6 months equaling a "".
This is the first formula.I need to do the same for the 2nd formula, which is the X item could start on the first month, then stop on the 6th month.
The first 6 months would be $1000 each and the last 6 months would be "".Thanks,
KT 
Hi,
I am trying to join 2 IF statements together and my patience is growing thin with this one. If you want to duplicate my efforts:
C13  effective date
C18  1st month of 12 months, i.e. 1/1/03 (term will almost never be a calendar year)
D13  value if true
""  value if false1st statement
=IF(((MONTH($C13)/12)+YEAR($C13))<=((MONTH($C$18)/12)+YEAR($C$18)),$D13,"")B13  end date
B18  last month of 12 months, i.e. 12/31/03 (term will almost never be a calendar year)
D13  value if true
""  value if false
2nd statement
=IF(((MONTH($B13)/12)+YEAR($B13))<=((MONTH($B$18)/12)+YEAR($B$18)),$D13,"")I am trying to automatically calculate 12 months (each in its own cell) based on the 'start date' and 'end date'.
For the 2nd months formula: add +1
=IF(((MONTH($C13)/12)+YEAR($C13))<=((MONTH($C$18)+1)/12)+YEAR($C$18)),$D13,"")
3rd month add +2 and so on.
If ANYONE gets what the heck I am babbling about, I would appreciate the help!
thanks,
kt