Forum Discussion

OSS's avatar
OSS
Helper III
7 years ago
Solved

IF function problem

Dear members   Actually I want to perform very simple task.   I have 'Account number' and 'Amount' column in my table. I would like to create new column with if condition   In Excel, it looks l...
Need Help
  • PattemManohar's avatar
    PattemManohar
    7 years ago

    OSS Please try this..

     

    NewAmount = IF(LEFT(Test181[Account],1)="1",Test181[Amount],IF(LEFT(Test181[Account])="2",Test181[Amount]*-1,0))

  • Anonymous's avatar
    Anonymous
    7 years ago

    hi,

     

    shouldnt it be like this:

     

    NewAmount = IF(LEFT(Test181[Account],1)="1",Test181[Amount],IF(LEFT(Test181[Account],1)="2",Test181[Amount]*-1,0))

     

PattemManohar's avatar
PattemManohar
Community Champion
7 years ago

Anonymous OSS

Thanks for that !! But anyway, the second parameter for LEFT function is optional. By default it will take 1 if we don't specify.

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

cheers ok, i didn't know that

 

thanks