excel come ottenere un risultato negativo dal prodotto di due valori negativi
40 views
Skip to first unread message
dogufo
unread,
May 13, 2023, 3:36:06 AM5/13/23
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Sign in to report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to
buongiorno, ho un quesito: come ottenere un risultato negativo dal rapporto di due valori negativi? In quanto necessito di avere un risultato negativo anche dal rapporto di due valori negativi i quali secondo la regola dei segni in aritmentica danno un rapporto positivo
grazie in anticipo per l' aiuto
issdr
unread,
May 13, 2023, 7:18:22 AM5/13/23
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Sign in to report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to
se i valori sono in A1 e B1:
=(1-2*(A1<0)*(B1<0))*A1*B1
issdr
unread,
May 13, 2023, 7:22:41 AM5/13/23
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Sign in to report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to
issdr wrote:
> se i valori sono in A1 e B1:
>
> =(1-2*(A1<0)*(B1<0))*A1*B1
=(1-2*(A1<0)*(B1<0))*A1/B1
refuso
dogufo
unread,
May 14, 2023, 4:38:21 AM5/14/23
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Sign in to report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to
non funziona per la mia necessità
risolto con questa formula =SE(E(E10<0;D10<0);-1*E10/D10;E10/D10)
issdr
unread,
May 16, 2023, 6:48:54 AM5/16/23
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Sign in to report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to
dogufo wrote:
>> =(1-2*(A1<0)*(B1<0))*A1/B1
[...]
> non funziona per la mia necessità
bastava esprimerla un po' meglio.
> risolto con questa formula =SE(E(E10<0;D10<0);-1*E10/D10;E10/D10)
bravo.
se sei curioso:
=(1-2*(E10<0)*(D10<0))*E10/D10
Bruno Campanini
unread,
May 18, 2023, 3:04:44 PM5/18/23
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Sign in to report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message