Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Troppe Funzioni....e quindi?

4 views
Skip to first unread message

SOS Comunità

unread,
Feb 7, 2012, 3:04:31 PM2/7/12
to
=SE(E42>15;"16-20";E42;SE(E42>20;"21-30";E42;SE(E42>30;"31-40";E42;SE(E42>40;"41-50";E42;SE(E42>50;"51-60";E42)))))

Come posso aggiustarla?

Grazie

Andrea.9

unread,
Feb 7, 2012, 3:35:29 PM2/7/12
to
On 7 Feb, 21:04, SOS Comunità <soscomun...@gmail.com> wrote:
> =SE(E42>15;"16-20";E42;SE(E42>20;"21-30";E42;SE(E42>30;"31-40";E42;SE(E42>4 0;"41-50";E42;SE(E42>50;"51-60";E42)))))
>
> Come posso aggiustarla?
>
> Grazie

cosi':
=SE(E42>50;"51-60";SE(E42>40;"41-50";SE(E42>30;"31-40";SE(E42>20;"21-30";SE(E42>15;"16-20";E42)))))
ciao
andrea

SOS Comunità

unread,
Feb 7, 2012, 3:41:44 PM2/7/12
to
On 7 Feb, 21:35, "Andrea.9" <a.novelli-...@dappolonia.it> wrote:
> On 7 Feb, 21:04, SOS Comunità <soscomun...@gmail.com> wrote:
>
> > =SE(E42>15;"16-20";E42;SE(E42>20;"21-30";E42;SE(E42>30;"31-40";E42;SE(E42>4 0;"41-50";E42;SE(E42>50;"51-60";E42)))))
>
> > Come posso aggiustarla?
>
> > Grazie
>
> cosi':
> =SE(E42>50;"51-60";SE(E42>40;"41-50";SE(E42>30;"31-40";SE(E42>20;"21-30";SE­(E42>15;"16-20";E42)))))
> ciao
> andrea

A Milan se diss "Che Pirla"! Riferito a me, ovviamente......
Grazie Andrea!
0 new messages