cap

How do I Cap if i want lets say -50% the minimum and +50% the max?.

I have the following formula - =(January!E3+February!E3+March!E3)/3. How woud I add a cap of 15%

Hi, I have the below data that I want to sum, but only to a certain point: <tbody> Number of cats 7 8 10 11 12 Cumulative cats 7 15 25 8 0 Cap on the number of cats 33 </tbody> I have information on the number of cats in each house, as can be seen it is 7 in...

I am trying to graph the frequency of a series of cap rates but want to also show the average age of properties that have that cap rate. For example, the chart will show there are 3 properties with a 6.5% cap rate, 6 properties with a 6.75% cap rate etc. but I also want to see the average age...

I have a macro that if a number is put into column F9:F80 it will puts a text in the next column. The issue I am have is I also track changes made to the sheet so when I click on any cell, the macro runs & even though there is already a number in column F & text in column G it will re-enter the...

Hello All! Via some google searches, I found a few similar questions answered by you fine people but didn't see my exact question and couldn't tweak on my own. Here is the scenario: Agent has an 80/20 split with the brokerage. If they sell 100000.00 house, they get 3% commission (3000) and...

<!--StartFragment--> Needing a month-to-date conversion tracking formula (based oncampaign_name[B], date [A], and summation of clicks [C]), assume column A is spanning all days and months through the end of year. Simple enough, I know,..but for whatever reason I'm struggling with setting up the...

hi all are there any syntax of how to change only the first word of the text or sentence to upper cap format using vba? so far in vba excel, there are only all lower cap, all upper cap and proper sentence.

Hello. I am one solid notch above novice, but a quick learner, and was hoping someone could help get me started with a solution. I have a large list of investments that contain various pieces of information (Name, Ticker, Asset Class, Performance data...). The list itself changes frequently...

Hi I'm a first time user motivated to join by the Excel problem I have. (Excel 2007/ Win 7) I'm attempting to set up a speadsheet to manage my savings. Each month I designate some of my income (x) towards my savings. I have multiple savings pots eg. emergency fund, kid's education fund...

So this is a rather difficult project-one with many answers and one where I'll need a lot of help. Please PM me or email me if that seems more reasonable. I'd appreciate any help you can offer. Heres the issue: I currently work with lots of Capitalization tables from different companies. These...