<div>
thanks both, my question was not clear enough thats why i split the points..
</div>


thanks both, my question was not clear enough thats why i split the points..

<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
I need to create a status if an list item is ready for invoicing.<br />
<br />
<br />
I need a calculated field (field3) with the following characteristics<br />
<br />
If field1 has a value then field3 should be 0<br />
if field2 = &quot;Cancelled&quot; then field3 should be 0<br />
If field1 has no value then field3 should be 1<br />
<br />
so calculated field3 should be either 0 or 1 <br />
<br />
thanks!
</div>
</div>


Hello,

I need to create a status if an list item is ready for invoicing.


I need a calculated field (field3) with the following characteristics

If field1 has a value then field3 should be 0
if field2 = "Cancelled" then field3 should be 0
If field1 has no value then field3 should be 1

so calculated field3 should be either 0 or 1 

thanks!

Calculated field sharepoint based on 2 fields

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Windows PowerShell is a task automation and configuration management framework from Microsoft, consisting of a command-line shell and associated scripting language built on the .NET Framework. PowerShell provides full access to the Component Object Model (COM) and Windows Management Instrumentation (WMI), enabling administrators to perform administrative tasks on both local and remote Windows systems as well as WS-Management and Common Information Model (CIM) enabling management of remote Linux systems and network devices.

Powershell

Microsoft Sharepoint is a software platform and family of software products used for collaboration and web publishing combined. These capabilities include developing web sites, portals, intranets, content management systems, search engines, wikis, blogs, and other tools for business intelligence and collaboration. SharePoint has a Microsoft Office-like interface, and it is closely integrated with the Office suite.