Un aiuto Per colonna <=0

Gandalf Il Bianco

New Member
Joined
Oct 31, 2023
Messages
1
Office Version
  1. 2007
Platform
  1. Windows
Buongiorno.
Mi scuso se vi disturbo con questo mio quesito forse banale.
Io ho un file excel cosi composto:
Colonna A Nome prodotto
Colonna B Inventario al 31/12/21
Colonna C Acquistato anno 2022
Colonna D Acquistato anno 2023
Colonna E Venduto nel 2022
Colonna F Venduto nel 2023.

Volevo sommare colonna BCD e sottrarre EF,solo Nei casi in cui la colonna B era Inferiore o uguuale a ZERO

Ho inserito questa formula,(
=SE(B11<=0, B11+C11+D11-E11-F11, 0)

)ma non riesco a farla funzionare

Cosa sbaglio?
 

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).
Hi, welcome to the forum :)

First of all, the general corresponding language of the forum is English. If you don't speak English, you can get assistance from an online translator.

Second, your formula seems to be OK. What kind of error are you getting?
 
Upvote 0
If your Excel is in Italian, I would suspect you need semicolons not commas:

Excel Formula:
=SE(B11<=0; B11+C11+D11-E11-F11; 0)
 
Upvote 0
Hai poi risolto il problema (col suggerimento di RoryA)?
 
Upvote 0

Forum statistics

Threads
1,224,862
Messages
6,181,461
Members
453,043
Latest member
Sronquest

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top