Thank you so much for all your help
On Thu, May 3, 2012 at 9:30 AM, David Grugeon wrote:
> If you want to calculate for a different net amount (m) just put the new
> value in the cell at the top marked "Target". All the calcs will then
> change. You can also change (h) if required but if
If you want to calculate for a different net amount (m) just put the new
value in the cell at the top marked "Target". All the calcs will then
change. You can also change (h) if required but if you change any of the
other formulas the whole exercise has to be reworked.
On 3 May 2012 13:49, Milin
Thanks David.
It is working. Though I am still trying to understand algebra :)
Just one more query : as data input value will change the formula will also
change , right ?
Regards,
Milin
On Thu, May 3, 2012 at 4:54 AM, David Grugeon wrote:
> Hi Milin
>
> I attach a revised version with worki
Dear David,
Thanks for your response.
Row 7 - "d oth all" is always a balancing number arrived on calculation.
This is one of the place where it goes in circular reference
The label for row 13 (G ESIC) is (a+b+c) x 4.75 % but the formula is
b+c+d x 4.75%. Which should it be? - I have changed
In your spreadsheet d will always be a - all the other deductions therefore
row 19 will always be zero. Is that what you wanted? If so you could
replace all the row 19 formulas with 0
The label for row 13 (G ESIC) is (a+b+c) x 4.75 % but the formula is
b+c+d x 4.75%. Which should it be?
If r
;> Formula.
>>>
>>> ** **
>>>
>>> *From:* excel-macros@googlegroups.com [mailto:
>>> excel-macros@googlegroups.com] *On Behalf Of *Milin Sulakhi
>>> *Sent:* Apr/Sat/2012 08:47
>>> *To:* excel-macros@googlegroups.com
>>> *Subjec
, 2012 at 9:24 PM, Rajan_Verma wrote:
>
>> ** **
>>
>> Formula.
>>
>> ** **
>>
>> *From:* excel-macros@googlegroups.com [mailto:
>> excel-macros@googlegroups.com] *On Behalf Of *Milin Sulakhi
>> *Sent:* Apr/Sat/2012 08:47
>> *To:* excel-
roups.com] *On Behalf Of *Milin Sulakhi
> *Sent:* Apr/Sat/2012 08:47
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Help required on how to create iterative
> formula
>
> ** **
>
> Dear Rajan,
>
> ** **
>
> But I will need to add formu
Formula.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Milin Sulakhi
Sent: Apr/Sat/2012 08:47
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Help required on how to create iterative
formula
Dear Rajan,
But I will need to add
Dear Rajan,
But I will need to add formula or values in cells marked Green in attached
file. Right ?
Regards,
Milin
On Sat, Apr 28, 2012 at 7:32 PM, Rajan_Verma wrote:
> Set the Maximum Iteration to 1 then Calculate formula by F2 and Enter
>
> ** **
>
> Rajan.
>
> ** **
>
> *From:* exc
Set the Maximum Iteration to 1 then Calculate formula by F2 and Enter
Rajan.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Milin Sulakhi
Sent: Apr/Sat/2012 06:42
To: excel-macros@googlegroups.com; milinsula...@gmail.com
Subject: $$Excel-Macros$$ Hel
11 matches
Mail list logo
