#### formula help #34

```cell J2 has starting balance of 500,000
cell J3 has running sum from column D
column D has both positive and negative entries
The running sum in cell J3 is 25% of total entries in column D
I need to subtract cell J3 from cell J2 but when I enter too many negative
numbers
the initial amount goes past 500,000 in J2.
How do I keep cell J2 from going past the initial 500,000?
Excel 97 SR-1
Thanks, Steve T

```
 0
stumas (15)
3/29/2007 1:44:19 AM
excel 39879 articles. 2 followers.

8 Replies
1151 Views

Similar Articles

[PageSpeed] 20

```If you're saying you don't want it to SHOW less than 500,000, then you could
use something like:
=IF(MYFORMULA<500,000,500,000,MYFORMULA)
If you want to be ALERTED when it's less than 500,000, then use conditional
formatting, perhaps, to give the cell a red fill. Format-->Conditional
formatting...
****************************
Hope it helps!
Anne Troy
www.OfficeArticles.com
****************************
"Steve T" <stumas@NOBINGOcharter.net> wrote in message
news:%23YJ9FPacHHA.4344@TK2MSFTNGP02.phx.gbl...
> cell J2 has starting balance of 500,000
> cell J3 has running sum from column D
> column D has both positive and negative entries
> The running sum in cell J3 is 25% of total entries in column D
> I need to subtract cell J3 from cell J2 but when I enter too many negative
> numbers
> the initial amount goes past 500,000 in J2.
> How do I keep cell J2 from going past the initial 500,000?
> Excel 97 SR-1
> Thanks, Steve T
>

```
 0
ng1 (1444)
3/29/2007 2:43:11 AM
```How is cell J2 changing?

It might help to give the exact formulas you're using in J2 and J3.

In article <#YJ9FPacHHA.4344@TK2MSFTNGP02.phx.gbl>,
"Steve T" <stumas@NOBINGOcharter.net> wrote:

> cell J2 has starting balance of 500,000
> cell J3 has running sum from column D
> column D has both positive and negative entries
> The running sum in cell J3 is 25% of total entries in column D
> I need to subtract cell J3 from cell J2 but when I enter too many negative
> numbers
> the initial amount goes past 500,000 in J2.
> How do I keep cell J2 from going past the initial 500,000?
> Excel 97 SR-1
> Thanks, Steve T
```
 0
jemcgimpsey (6723)
3/29/2007 3:45:47 AM
```Sent reply to JE only by mistake sorry. Here was my reply:
J2 cell formula is =SUM(500000-J3)
J3 cell formula is =SUMIF(D10:D402,">0")
I'm looking to eliminate the amount of 500000 at the rate of  applying 25%
to the sum in column D in J3. Currently there are two negative amounts
totaling 140 and one positive amount for 35. Only the 35 is subtracted from
the 500000 in J2. It should be a negative amount. The 25% should only be
applied if it appears as a "profit". Steve T

"JE McGimpsey" <jemcgimpsey@mvps.org> wrote in message
news:jemcgimpsey-4E5957.21454728032007@msnews.microsoft.com...
> How is cell J2 changing?
>
>
> It might help to give the exact formulas you're using in J2 and J3.
>
>
> In article <#YJ9FPacHHA.4344@TK2MSFTNGP02.phx.gbl>,
> "Steve T" <stumas@NOBINGOcharter.net> wrote:
>
>> cell J2 has starting balance of 500,000
>> cell J3 has running sum from column D
>> column D has both positive and negative entries
>> The running sum in cell J3 is 25% of total entries in column D
>> I need to subtract cell J3 from cell J2 but when I enter too many
>> negative
>> numbers
>> the initial amount goes past 500,000 in J2.
>> How do I keep cell J2 from going past the initial 500,000?
>> Excel 97 SR-1
>> Thanks, Steve T

```
 0
stumas (15)
3/29/2007 5:12:22 AM
```On Wed, 28 Mar 2007 22:12:22 -0700, "Steve T"
<stumas@NOBINGOcharter.net> wrote:

>Sent reply to JE only by mistake sorry. Here was my reply:
>J2 cell formula is =SUM(500000-J3)
>J3 cell formula is =SUMIF(D10:D402,">0")
>I'm looking to eliminate the amount of 500000 at the rate of  applying 25%
>to the sum in column D in J3. Currently there are two negative amounts
>totaling 140 and one positive amount for 35. Only the 35 is subtracted from
>the 500000 in J2. It should be a negative amount. The 25% should only be
>applied if it appears as a "profit". Steve T

In cell J2 try this:

=max(0,500000-(J3*.25))

Jim

>
>"JE McGimpsey" <jemcgimpsey@mvps.org> wrote in message
>news:jemcgimpsey-4E5957.21454728032007@msnews.microsoft.com...
>> How is cell J2 changing?
>>
>>
>> It might help to give the exact formulas you're using in J2 and J3.
>>
>>
>> In article <#YJ9FPacHHA.4344@TK2MSFTNGP02.phx.gbl>,
>> "Steve T" <stumas@NOBINGOcharter.net> wrote:
>>
>>> cell J2 has starting balance of 500,000
>>> cell J3 has running sum from column D
>>> column D has both positive and negative entries
>>> The running sum in cell J3 is 25% of total entries in column D
>>> I need to subtract cell J3 from cell J2 but when I enter too many
>>> negative
>>> numbers
>>> the initial amount goes past 500,000 in J2.
>>> How do I keep cell J2 from going past the initial 500,000?
>>> Excel 97 SR-1
>>> Thanks, Steve T
>

```
 0
anon7218 (27)
3/29/2007 5:36:45 AM
```I guess I'm confused as to what you're trying to accomplish.

J3 will always be zero or positive since the SUMIF() only sums positive
numbers.

J2 will always be less than or equal to 500000 since you're subtracting
a zero or positive value from 500000. (Note that the SUM() is not
needed, you could use

=500000 - J3

without the overhead of the SUM function.)

So I don't know what "It" you mean when you say that "It should be a
negative amount".

Note that 35 is not 25% of -140 (if anything it's -25%, but language
gets tricky when talking about %'s and sign changes).

If you want to J3 to be 25% of the total of column D, but only if the
column D sum is positive, then it sounds like you want

J3:     =MAX(0, SUM(D:D) * 25%)

In article <u\$03WDccHHA.208@TK2MSFTNGP05.phx.gbl>,
"Steve T" <stumas@NOBINGOcharter.net> wrote:

> J2 cell formula is =SUM(500000-J3)
> J3 cell formula is =SUMIF(D10:D402,">0")
> I'm looking to eliminate the amount of 500000 at the rate of  applying 25%
> to the sum in column D in J3. Currently there are two negative amounts
> totaling 140 and one positive amount for 35. Only the 35 is subtracted from
> the 500000 in J2. It should be a negative amount. The 25% should only be
> applied if it appears as a "profit". Steve T
>
> "JE McGimpsey" <jemcgimpsey@mvps.org> wrote in message
> news:jemcgimpsey-4E5957.21454728032007@msnews.microsoft.com...
> > How is cell J2 changing?
> >
> >
> > It might help to give the exact formulas you're using in J2 and J3.
> >
> >
> > In article <#YJ9FPacHHA.4344@TK2MSFTNGP02.phx.gbl>,
> > "Steve T" <stumas@NOBINGOcharter.net> wrote:
> >
> >> cell J2 has starting balance of 500,000
> >> cell J3 has running sum from column D
> >> column D has both positive and negative entries
> >> The running sum in cell J3 is 25% of total entries in column D
> >> I need to subtract cell J3 from cell J2 but when I enter too many
> >> negative
> >> numbers
> >> the initial amount goes past 500,000 in J2.
> >> How do I keep cell J2 from going past the initial 500,000?
> >> Excel 97 SR-1
> >> Thanks, Steve T
```
 0
jemcgimpsey (6723)
3/29/2007 12:12:02 PM
```Crap I did it again by not replying to group, sorry.
I'm trying to figure out a payment schedule of 25% of profits with a
starting balance of 500000. If there is no "profit" then there is no 25%
payment. The numbers will be entered daily, negative or positive; and if at
the end of the month there is a profit, then you owe me 25% of that profit
until the 500000 is paid off. If you do not make a profit for the month, you
owe me nothing; but the original 500000 does not increase. I'm trying to
make the worksheet capable of daily entries with running totals. That's
about as "simple" as I can make it. Thanks for all of the effort, Steve T.

"JE McGimpsey" <jemcgimpsey@mvps.org> wrote in message
news:jemcgimpsey-C97D86.06120229032007@msnews.microsoft.com...
>I guess I'm confused as to what you're trying to accomplish.
>
> J3 will always be zero or positive since the SUMIF() only sums positive
> numbers.
>
> J2 will always be less than or equal to 500000 since you're subtracting
> a zero or positive value from 500000. (Note that the SUM() is not
> needed, you could use
>
>    =500000 - J3
>
> without the overhead of the SUM function.)
>
> So I don't know what "It" you mean when you say that "It should be a
> negative amount".
>
> Note that 35 is not 25% of -140 (if anything it's -25%, but language
> gets tricky when talking about %'s and sign changes).
>
> If you want to J3 to be 25% of the total of column D, but only if the
> column D sum is positive, then it sounds like you want
>
> J3:     =MAX(0, SUM(D:D) * 25%)
>
>
>
> In article <u\$03WDccHHA.208@TK2MSFTNGP05.phx.gbl>,
> "Steve T" <stumas@NOBINGOcharter.net> wrote:
>
>> J2 cell formula is =SUM(500000-J3)
>> J3 cell formula is =SUMIF(D10:D402,">0")
>> I'm looking to eliminate the amount of 500000 at the rate of  applying
>> 25%
>> to the sum in column D in J3. Currently there are two negative amounts
>> totaling 140 and one positive amount for 35. Only the 35 is subtracted
>> from
>> the 500000 in J2. It should be a negative amount. The 25% should only be
>> applied if it appears as a "profit". Steve T
>>
>> "JE McGimpsey" <jemcgimpsey@mvps.org> wrote in message
>> news:jemcgimpsey-4E5957.21454728032007@msnews.microsoft.com...
>> > How is cell J2 changing?
>> >
>> >
>> > It might help to give the exact formulas you're using in J2 and J3.
>> >
>> >
>> > In article <#YJ9FPacHHA.4344@TK2MSFTNGP02.phx.gbl>,
>> > "Steve T" <stumas@NOBINGOcharter.net> wrote:
>> >
>> >> cell J2 has starting balance of 500,000
>> >> cell J3 has running sum from column D
>> >> column D has both positive and negative entries
>> >> The running sum in cell J3 is 25% of total entries in column D
>> >> I need to subtract cell J3 from cell J2 but when I enter too many
>> >> negative
>> >> numbers
>> >> the initial amount goes past 500,000 in J2.
>> >> How do I keep cell J2 from going past the initial 500,000?
>> >> Excel 97 SR-1
>> >> Thanks, Steve T

```
 0
stumas (15)
3/29/2007 5:44:18 PM
```Hi Steve

Is it not
J2=500,000-J3
J3=IF(SUM(D10:D402)>0,SUM(D10:D402)*25%,0)

--
Regards

Roger Govier

"Steve T" <stumas@NOBINGOcharter.net> wrote in message
news:%237TNhnicHHA.4656@TK2MSFTNGP06.phx.gbl...
> Crap I did it again by not replying to group, sorry.
> I'm trying to figure out a payment schedule of 25% of profits with a
> starting balance of 500000. If there is no "profit" then there is no
> 25%
> payment. The numbers will be entered daily, negative or positive; and
> if at
> the end of the month there is a profit, then you owe me 25% of that
> profit
> until the 500000 is paid off. If you do not make a profit for the
> month, you
> owe me nothing; but the original 500000 does not increase. I'm trying
> to
> make the worksheet capable of daily entries with running totals.
> That's
> about as "simple" as I can make it. Thanks for all of the effort,
> Steve T.
>
> "JE McGimpsey" <jemcgimpsey@mvps.org> wrote in message
> news:jemcgimpsey-C97D86.06120229032007@msnews.microsoft.com...
>>I guess I'm confused as to what you're trying to accomplish.
>>
>> J3 will always be zero or positive since the SUMIF() only sums
>> positive
>> numbers.
>>
>> J2 will always be less than or equal to 500000 since you're
>> subtracting
>> a zero or positive value from 500000. (Note that the SUM() is not
>> needed, you could use
>>
>>    =500000 - J3
>>
>> without the overhead of the SUM function.)
>>
>> So I don't know what "It" you mean when you say that "It should be a
>> negative amount".
>>
>> Note that 35 is not 25% of -140 (if anything it's -25%, but language
>> gets tricky when talking about %'s and sign changes).
>>
>> If you want to J3 to be 25% of the total of column D, but only if the
>> column D sum is positive, then it sounds like you want
>>
>> J3:     =MAX(0, SUM(D:D) * 25%)
>>
>>
>>
>> In article <u\$03WDccHHA.208@TK2MSFTNGP05.phx.gbl>,
>> "Steve T" <stumas@NOBINGOcharter.net> wrote:
>>
>>> J2 cell formula is =SUM(500000-J3)
>>> J3 cell formula is =SUMIF(D10:D402,">0")
>>> I'm looking to eliminate the amount of 500000 at the rate of
>>> applying 25%
>>> to the sum in column D in J3. Currently there are two negative
>>> amounts
>>> totaling 140 and one positive amount for 35. Only the 35 is
>>> subtracted from
>>> the 500000 in J2. It should be a negative amount. The 25% should
>>> only be
>>> applied if it appears as a "profit". Steve T
>>>
>>> "JE McGimpsey" <jemcgimpsey@mvps.org> wrote in message
>>> news:jemcgimpsey-4E5957.21454728032007@msnews.microsoft.com...
>>> > How is cell J2 changing?
>>> >
>>> >
>>> > It might help to give the exact formulas you're using in J2 and
>>> > J3.
>>> >
>>> >
>>> > In article <#YJ9FPacHHA.4344@TK2MSFTNGP02.phx.gbl>,
>>> > "Steve T" <stumas@NOBINGOcharter.net> wrote:
>>> >
>>> >> cell J2 has starting balance of 500,000
>>> >> cell J3 has running sum from column D
>>> >> column D has both positive and negative entries
>>> >> The running sum in cell J3 is 25% of total entries in column D
>>> >> I need to subtract cell J3 from cell J2 but when I enter too many
>>> >> negative
>>> >> numbers
>>> >> the initial amount goes past 500,000 in J2.
>>> >> How do I keep cell J2 from going past the initial 500,000?
>>> >> Excel 97 SR-1
>>> >> Thanks, Steve T
>
>

```
 0
roger5293 (1125)
3/29/2007 11:51:05 PM
```Thanks Roger, that formula keeps it at 500000 id there is no profit to pay.
Steve T.
"Roger Govier" <roger@technologyNOSPAM4u.co.uk> wrote in message
news:OVNBl0lcHHA.648@TK2MSFTNGP04.phx.gbl...
> Hi Steve
>
> Is it not
> J2=500,000-J3
> J3=IF(SUM(D10:D402)>0,SUM(D10:D402)*25%,0)
>
> --
> Regards
>
> Roger Govier
>
>
> "Steve T" <stumas@NOBINGOcharter.net> wrote in message
> news:%237TNhnicHHA.4656@TK2MSFTNGP06.phx.gbl...
>> Crap I did it again by not replying to group, sorry.
>> I'm trying to figure out a payment schedule of 25% of profits with a
>> starting balance of 500000. If there is no "profit" then there is no 25%
>> payment. The numbers will be entered daily, negative or positive; and if
>> at
>> the end of the month there is a profit, then you owe me 25% of that
>> profit
>> until the 500000 is paid off. If you do not make a profit for the month,
>> you
>> owe me nothing; but the original 500000 does not increase. I'm trying to
>> make the worksheet capable of daily entries with running totals. That's
>> about as "simple" as I can make it. Thanks for all of the effort, Steve
>> T.
>>
>> "JE McGimpsey" <jemcgimpsey@mvps.org> wrote in message
>> news:jemcgimpsey-C97D86.06120229032007@msnews.microsoft.com...
>>>I guess I'm confused as to what you're trying to accomplish.
>>>
>>> J3 will always be zero or positive since the SUMIF() only sums positive
>>> numbers.
>>>
>>> J2 will always be less than or equal to 500000 since you're subtracting
>>> a zero or positive value from 500000. (Note that the SUM() is not
>>> needed, you could use
>>>
>>>    =500000 - J3
>>>
>>> without the overhead of the SUM function.)
>>>
>>> So I don't know what "It" you mean when you say that "It should be a
>>> negative amount".
>>>
>>> Note that 35 is not 25% of -140 (if anything it's -25%, but language
>>> gets tricky when talking about %'s and sign changes).
>>>
>>> If you want to J3 to be 25% of the total of column D, but only if the
>>> column D sum is positive, then it sounds like you want
>>>
>>> J3:     =MAX(0, SUM(D:D) * 25%)
>>>
>>>
>>>
>>> In article <u\$03WDccHHA.208@TK2MSFTNGP05.phx.gbl>,
>>> "Steve T" <stumas@NOBINGOcharter.net> wrote:
>>>
>>>> J2 cell formula is =SUM(500000-J3)
>>>> J3 cell formula is =SUMIF(D10:D402,">0")
>>>> I'm looking to eliminate the amount of 500000 at the rate of applying
>>>> 25%
>>>> to the sum in column D in J3. Currently there are two negative amounts
>>>> totaling 140 and one positive amount for 35. Only the 35 is subtracted
>>>> from
>>>> the 500000 in J2. It should be a negative amount. The 25% should only
>>>> be
>>>> applied if it appears as a "profit". Steve T
>>>>
>>>> "JE McGimpsey" <jemcgimpsey@mvps.org> wrote in message
>>>> news:jemcgimpsey-4E5957.21454728032007@msnews.microsoft.com...
>>>> > How is cell J2 changing?
>>>> >
>>>> >
>>>> > It might help to give the exact formulas you're using in J2 and J3.
>>>> >
>>>> >
>>>> > In article <#YJ9FPacHHA.4344@TK2MSFTNGP02.phx.gbl>,
>>>> > "Steve T" <stumas@NOBINGOcharter.net> wrote:
>>>> >
>>>> >> cell J2 has starting balance of 500,000
>>>> >> cell J3 has running sum from column D
>>>> >> column D has both positive and negative entries
>>>> >> The running sum in cell J3 is 25% of total entries in column D
>>>> >> I need to subtract cell J3 from cell J2 but when I enter too many
>>>> >> negative
>>>> >> numbers
>>>> >> the initial amount goes past 500,000 in J2.
>>>> >> How do I keep cell J2 from going past the initial 500,000?
>>>> >> Excel 97 SR-1
>>>> >> Thanks, Steve T
>>
>>
>
>

```
 0
stumas (15)
3/30/2007 12:56:17 AM

Similar Artilces:

This is a multi-part message in MIME format. ------=_NextPart_000_0008_01C47622.DFEC7DC0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I am using Microsoft Money Premium for household budgets etc. It was = working fine then all of a sudden it will not let me enter any new = entries or even alter existing entries. I just get a message that says = "This transaction cannot be entered". What can I do or what have I done????? ------=_NextPart_000_0008_01C47622.DFEC7DC0 Content-Type: text/html; charset="iso-8859-1" Conten...

HELP! #2
I just had a cluster failover and fail back and for whatever reason, now when users go into Outlook and type the name of a public folder or newsgroup on the To: line they see the name of the group plus some sort of SID looking string next to it. For example, instead of just seeing thename of the group they are seeing: company.newsgroupname <newsgroupname34239492038902385092845923> What's going on? Help! Dan Dan, Are there any errors in the event logs pertaining to access of AD or anything like that? C. Smith Enso Technologies, Incorporated http://www.ensotech.com On Wed,...

Iterative Calculation help needed
I have the following information A1 - Balance at the beginning of calculation A2 - Annualized payment A3 - Interest rate divided by # of payments per year A4 - Number of years * # of payments per year I'm trying to calulate the total ((A1-A2)*(1+A3)) - I need to do this over and over up until I've don it A4 times. I can do it for each period but I want to do it all in one cell, i possible. How can I have it plug the new number into A1 and repeat th calculation A4 times. Thanks -- Message posted from http://www.ExcelForum.com Hi there You might find that the PMT function coul...

i am receiving every emai twice?? can anyone help with this issue
I would appreciate any advice cheers, See http://www.howto-outlook.com/faq/duplicates.htm -- Robert Sparnaaij [MVP-Outlook] Coauthor, Configuring Microsoft Outlook 2003 http://www.howto-outlook.com/ Outlook FAQ, HowTo, Downloads, Add-Ins and more http://www.msoutlook.info/ Real World Questions, Real World Answers ----- "ETA" <ETA@discussions.microsoft.com> wrote in message news:5939A41A-2CBC-415A-BA84-C14C2FD19084@microsoft.com... > I would appreciate any advice > > cheers, ...

Excel Formulae #4
I've been trying hard to find a formula which would enable me (from one cell) to Add several cells and Subtract the answer from another cell (subtracting items of expenditure from a starting total). I could manage this with Lotus - but Excel does not seem to behave the same. Advice would be much appreciated. Thanks, Ken. One way: Say you wanted to subtract A1, A2, A3, J4 and N5 from L6: =L6-SUM(A1:A3,J4,N5) In article <173d01c3fbd6\$3df0f300\$a401280a@phx.gbl>, "KenS." <anonymous@discussions.microsoft.com> wrote: > I've been trying hard ...

Need HELP with Exchange Restore/Recovery
Details: 2003 sp2 Exchange Server Enterprise 2003 sp1 Server Enterprise C: drive is 100GB Logical Drive over x4 36GB drives in a RAID 5 set D: drive is 280GB Logical Drive over x5 70GB drives in a RAID 5 set Domain Controller Last night I upgraded our 2003 sp1 Exchange to sp2 + any O/S hot fixes and DST fix. No problem with the upgrade or hot fix, but @ about 200 a.m. I lost two of the five drives in the RAID 5 set (drive D) that had the exchange install. I’m currently replacing the hardware & bringing up the drives & going to recreate the D: drive. (server is bootable) I h...

Shorter Formula
Can anyone shorten this formula please. Basically all it does is gives me an average of the figures in Column "W" depending on the number of times that product appears in "R" column =IF(ISERROR(SUM(SUMIF(\$R\$5:\$R\$9,R62,\$W\$5:\$W\$9),SUMIF (\$R\$22:\$R\$26,R62,\$W\$22:\$W\$26),SUMIF (\$R\$39:\$R\$43,R62,\$W\$39:\$W\$43))/COUNTIF (\$R\$5:\$R\$43,R62)),0,SUM(SUMIF (\$R\$5:\$R\$9,R62,\$W\$5:\$W\$9),SUMIF (\$R\$22:\$R\$26,R62,\$W\$22:\$W\$26),SUMIF (\$R\$39:\$R\$43,R62,\$W\$39:\$W\$43))/COUNTIF(\$R\$5:\$R\$43,R62)) thanks Pete I didn't try too hard to analyze your formula, just noted that your ranges and sum_ ranges...

Formula counts incorrectly
Help please. Column K contains dates and blank cells. I would like to count how many of these dates fall within a given date range. For example, in the first week in May. Column K contains these dates. 5/2/2005, 5/3/2005, 5/5/2005, 5/5/2005. I would like to count this as 4 dates within the first week of May. I created this formula but the output is 3. =SUMPRODUCT(--(ECNT!F2:F515>=DATE(2005,5,2)),--(ECNT!F2:F515<=DATE(2005,5,6)),--(ISNUMBER(ECNT!K2:K515))) I assume that it is only counting 5/5/2005 one time? I changed the dates in the formula to check a second 2nd date range (5/9 to ...

Hi All, I have two questions first is where do I find the Windows 7 Disscussion Group. Have posted here because was unable to locate the windows 7 Discussion Group. My computer which is a SAMSUNG N110 3 months old has become very very very slow. It has Windows 7 installed I have upgraded the memory to two GIG. I have antivirus software and Anti Malware bytes installed. The problem i have is that the machine seems to slow down and sometimes crash whenever I click on internet explorer and many other applications such as office 2007 etc, etc. I have run the Norton Virus pr...

Help!! Need Recovery!
So I went to open my excell file as usual and suddenly I have 10 or so instances openned. As I was closing them I saved one that turned out to be an old version, REAL OLD, like 2 weeks or so. No I desparataly need to get back to where I was. I tried to use the recovery utility under Microsoft Tools, but there are no available dates to revert to. I have no other way of reverting the document. Anyone know what to do? Any help would be greatly appreciated! Thank you.- Kjellster :D ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and ...

Protect formatting & formula
I need to protect the formatting & formula in each cell to avoid accidental changes during update by different users. However, if I protect them, any new row creation and deletion are disable. Is there any way resolve it? Especially, when create a row, how can all formatting and formula to create automatically for the new row? Thanks, Scott What version of Excel? "Scott" <NoSpam-Scott.Xe@GMail.com> wrote in message news:%23bsg6kCBGHA.4092@TK2MSFTNGP09.phx.gbl... >I need to protect the formatting & formula in each cell to avoid accidental >changes d...

Is there a way to automatically put the \$ sign into the formula?
I want to turn this =A1 into =\$A\$1. How is the best way of doing this. Is there a shortcut....keyboard stroke to do this?? Hit [F4] several times and watch the results. Micky "hrb_2001" wrote: > I want to turn this =A1 into =\$A\$1. > How is the best way of doing this. Is there a shortcut....keyboard stroke to > do this?? > Hi, Enter =A1 then tap F4 Repeated taps of F4 scroll through the referencing options -- Mike When competing hypotheses are equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently an...

Help to build a table
Please help me to build a table similar to this one The number on the first column will change after 16 times, it will go in sequence from 1001, 1002, etc… The number in the second column will change after 4 times and it will go from 1 to 4 The number in the 3rd column will go from 1 to 4 2nd and 3rd column will keep the same pattern. Cabinet Shelf Location 1001 1 1 1001 1 2 1001 1 3 1001 1 4 1001 2 1 1001 2 2 1001 2 3 1001 2 4 1001 3 1 1001 3 2 1001 3 3 1001 3 4 1001 4 1 1001 4 2 1001 4 3 1001 4 4 1002 1 1 1002 1 2 1002 1 3 1002 1 4 1002 2 1 1002 2 2 1002 2...

My computer has stopped recognizing my memory card
This just happened today. The card was purchased the day after Thanksgiving so it's very new. It is a 4GB SD card from HP. I don't believe this is a hardware problem as my digital camera Lexar 1GB Memory Stick Duo card and adapter worked just fine today in the same slot. There has been no damage to the card. It has a write-protection lock on the side and I've tried the card with and without the lock on - neither way worked. I've also checked "My Computer" and confirmed that the computer is not listing my card as a drive any longer. I really need to get t...

Help writing a formula
I have a huge database that I need to create numbering for each line like this example: AK-233 (2 letter state, a dash, and 1-4 digit number), but the number doesn't change each line - sometimes the number will be duplicated on multiple lines because those lines have the same title, I also need to create another cell extending that letter/number combo that will differentiate the 1st cell. So the first cell stays the same if the title is the same. The second cell adds another layer of numbering to differentiate the first cell. See example: (Row1, Col 1-4) AK-1, AK-1-1, Title1...

Receiving 2 of every message
I recently paid for a hotmail account so I could have larger storage and not get cancelled for any reasons such as not checking it often enough. I followed the instructions and put my service on Outlook Express. Now I'm receiving 2 of every message. What's up? Can I fix this? Thanks Darla ...

Help with RANK
Hi I need to rank 100+ numbers but I can't get the formula right. All th numbers are in one column, but not all the rows e.g. I need to Ran G1:G11 and G13:G25 and G32:G40 etc. How can you put in more than on reference? The cells G12,G26:G31 etc have numbers in them that I don' want ranked RANK(number,ref,order -- Message posted from http://www.ExcelForum.com =RANK(G1,MyList) where mylist is a selection of ranges defined with a single name, eg select all your ranges and do Insert / Name / Define, then call it MyList. Now use it in the rank formula and then copy the formula ...

HELP! Outlook Keeps Receiving Same E-Mail Messages
Hello: I keep getting the same 6 e-mail messages. This is after calling Norton and Comcast re receiving the same 3 e-mail messages (538 of them since midnight Dec 3!). Of course, it was not their problem, so it must be Outlook. Any thoughts. It sounds like you have an email message with a large attachment that is bogging down your account. What happens with the email is once you have connected to your ISP and clicked on the send/receive button if the connection is lost it will start over again until it can pull all of your messages in 1 sweep. You will need to log on to your accou...

Dialog getting hidden under HELP file
HI all, In my application I have a dialog & I launch HELP file from that dialog using F1 key. After that If I move the help file to one corner so that a part of the dialog is visible & click on the dialog & move it,it is moving,but when it comes over the HELP file,it is not overlapping but getting hidden under that. can anybody tell me what should I do to make it overlap the help file or give me a link that can help. Thanks in advance. Yes, that's how it is supposed to work. Help is a completely separate program, so its relationship to windows in ...

Money 2005 #34
Perhaps I don't quite understand how to use Money, it's all new to me but this is my question, When I create an invoice and I receive that invoice into my business account it shows as "payment for invoice" but when the check for that invoice is deposited into my bank it shows up as 2 deposits when I download info from the bank. I can't get them to "match" as the "payment for invoice" does not show as an income. Am I missing something? -- Any help will be greatly appreciated, MtnMaine I'm sorry to hear that you are having this problem because...