Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

How to skip empty when calculate difference?

Hello,    I need a new column to calculate the difference bewteen Column A & B, but B has some empty cells which should be ingored. Please advise.  
Need Help
  • Rohit11's avatar
    Rohit11
    2 years ago

    Try 

     

    Difference = IF( ISBLANK([ColumnB]), BLANK(), [ColumnA] - [ColumnB] )

    Thank you. 

     Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Rohit11's avatar
Rohit11
Resolver II
2 years ago

Try 

 

Difference = IF( ISBLANK([ColumnB]), BLANK(), [ColumnA] - [ColumnB] )

Thank you. 

 Don't forget to give thumbs up and accept this as a solution if it helped you!!!