Excel 2003 - 7 nested IF's
Excel 2007 - 64 nested IF's
On Sat, Aug 14, 2010 at 10:43 AM, Angelo Spinola wrote:
> Hi, Thanks for the feedback,
>
> So what i mean is how many nested IF's can i have?
>
> Regards,
> Angelo
>
> 2010/8/14 Bruno Bruno
>
> Angelo, I didn't use iteration.
>> Perhaps you
Hi, Thanks for the feedback,
So what i mean is how many nested IF's can i have?
Regards,
Angelo
2010/8/14 Bruno Bruno
> Angelo, I didn't use iteration.
> Perhaps you're confusing the concept of iteration with something else.
> Iteration is a special kind of resource in writing formulas for ex
Angelo, I didn't use iteration.
Perhaps you're confusing the concept of iteration with something else.
Iteration is a special kind of resource in writing formulas for excel, that
takes advantage of circular references. Google for "excel iteration" for
more on this, or see for example here:
http://p
Hi,
thanks, yes, is the number of if iteration ilimited?
Regards
2010/8/12 Bruno Bruno
> See if it's this what you want.
>
>
> On Thu, Aug 12, 2010 at 12:40 PM, Angelo Spinola
> wrote:
>
>> Dear Bruno,
>>
>> I will send you an attachment, so i can make this clear. Result is based
>> on size a
See if it's this what you want.
On Thu, Aug 12, 2010 at 12:40 PM, Angelo Spinola wrote:
> Dear Bruno,
>
> I will send you an attachment, so i can make this clear. Result is based on
> size and code as you can see... i have put some sample data for column that
> i desire that is result.
>
> Regard
Dear Bruno,
I will send you an attachment, so i can make this clear. Result is based on
size and code as you can see... i have put some sample data for column that
i desire that is result.
Regards,
Angelo Spinola
2010/8/12 Bruno Bruno
> Hi Angelo,
> I'm still confused about exactly what you wa
Hi Angelo,
I'm still confused about exactly what you want. Are you really sure you're
looking for an iteration?
You say that If in cell A1 i have "aaa" it should stay the same, but if i
have "bbb" it should be changed to "ccc" , but cell A1 *has* "aaa" or *
displays* "aaa"?
- If it has "aaa", then
Dear Bruno,
Thanks for the feedback.
If in cell A1 i have "aaa" it should stay the same, but if i have "bbb" it
should be changed to "ccc".
Regards
2010/8/11 Bruno Bruno
> Hi,
> I am not pretty sure of what you want, but aren't you looking for a simple
> formula? Something like:
>
> =IF(MOD(
Hi,
I am not pretty sure of what you want, but aren't you looking for a simple
formula? Something like:
=IF(MOD(CODE(A1);2)=1;A1;REPT(CHAR(CODE(A1)+1);3))
Where A1 is the cell with "aaa"
On Tue, Aug 10, 2010 at 6:23 PM, Angelo Spinola wrote:
> Hello,
>
>
> How can i create and iteration for:
>
