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!!!

1 Reply

  • 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!!!