Sharepoint online calculated columns

Question

I created a calculated column to test if too other columns in the same list are empty (Blank), but my own formula didn't work I need help please !

Answer 1

Hello @Mustapha Ait Bencheikh ,

Use the following formula to count the number of blank fields.

=IF(ISBLANK(Title),1,0)+IF(ISBLANK(ColumnA),1,0) + IF(ISBLANK(ColumnB),1,0)  
#When the value is 0, it means that no field is empty  

Thanks,
Echo Du

====================
Updated Answer ===================

Hi @Mustapha Ait Bencheikh ,

Please use the following formula:

=IF(OR(ISBLANK([DATE DE REMBOURSEMENT OU RETOUR]),ISBLANK([MONTANT REMBOURSE])),"Non Remboursé","Remboursé")  

Thanks,
Echo Du

================

If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

@Echo Du_MSFT
The code works finaly but this is not what I need, I need when the both fields or one of them empty return "Non Remboursé" else "Remboursé" is that possible becouse I tried to modify your code and still errors