Forum Discussion

Herson's avatar
Herson
Regular Visitor
4 years ago
Solved

Financial analysis: How to make calculation that meets certain condition with nested if statement

Hi all,

 

I have a financial calculation problem to ask and would appreciate any kind help!

In the table below,  AA_100010 and AA_100020 are empty numbers. They are values from additions of other cells.

What I would like to have is creating a new column in Power Query where

IF [AACT_NUMBER]= AA_100010 Then [New Value] is AA_100011+AA_100014 which equals to 17

ELSE IF [AACT_NUMBER]= AA_100020 Then [New Value] is AA_100021 + AA_100023 which equals to 26

ELESE Return values in the [VALUE] column 

 

Thanks in advance for the help from Taiwan!