Share via

SharePoint : Multiple Nested Formula in Calculated Column

  • Article

Applies to

  • SharePoint 2016
  • SharePoint Online
  • SharePoint 2013
  • SharePoint 2010

Issue

There are multiple threads in forum for looking for answer of "Multiple Nested Formula in Calculated Column".

Trying to build the below formula in one column, but keeping running into errors

I'm trying to build the following:

If CX Type = ReDev then 6000

If CX Type = New Build then 100000

If CX Type = Rip & Replace then 250000

However, if the following is true, then amount should be 0

If Cx Status = Cancelled then 0

If Cx Status = Lost then 0

If Cx Status = Complete then 0

Solution

Here is available solution for above requirement:

=IF(OR([CX Status]="Cancelled", [CX Status]="Lost", [CX Status]="Complete"),"0",(IF([Cx Type]="ReDev","6000",(IF([Cx Type]="New Build","100000",(IF([Cx Type]="Rip & Replace","250000")))))))