cancel
Showing results for
Did you mean:
Highlighted
Level: Powered On

## How to make "if conditions" in CDS work like Excel "if conditions" : Calculated fields

I have been trying to achieve the following in a if condition in a calulated field , Could you please help me the achieve this kind of values which are dynamic.

By default the if condition only allows a "static value" or a "field value " , is there any way i can have a computed "field value" as follows , this is the formula based on excel , i need to achieve the same in CDS calculated fields

```=IF(
BX\$4 <= \$AI5,
IF(
OR(
BX\$4 = \$AH5 + 1,
BX\$4 = \$AH5 * 2 + 1,
BX\$4 = \$AH5 * 3 + 1,
BX\$4 = \$AH5 * 4 + 1,
BX\$4 = \$AH5 * 5 + 1,
BX\$4 = \$AH5 * 6 + 1,
BX\$4 = \$AH5 * 7 + 1,
BX\$4 = \$AH5 * 8 + 1,
BX\$4 = \$AH5 * 9 + 1,
BX\$4 = \$AH5 * 10 + 1,
BX\$4 = \$AH5 * 11 + 1,
BX\$4 = \$AH5 * 12 + 1,
BX\$4 = \$AH5 * 13 + 1,
BX\$4 = \$AH5 * 14 + 1,
BX\$4 = \$AH5 * 15 + 1,
BX\$4 = \$AH5 * 16 + 1,
BX\$4 = \$AH5 * 17 + 1,
BX\$4 = \$AH5 * 18 + 1,
BX\$4 = \$AH5 * 19 + 1,
BX\$4 = \$AH5 * 20 + 1
),
BW5 * ( 1 + \$AE5 ),
BW5
),
0
) ```

Announcements

#### Watch Sessions On Demand!

Continue your learning in our online communities.

Stay Up-to-Date by following PowerApps on Twitter

#### Top Community Contributors for July 2019

Let's thank our top community contributors

#### Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

#### Power Platform World Tour

Coming to a city near you

#### PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

#### Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

#### Dynamics 365 and Power Platform April 2019 Release notes

Features releasing from April 2019 through September 2019!

Top Kudoed Authors
Users Online
Currently online: 52 members 4,016 guests
Recent signins: