dimanche 9 mai 2021

Dynamic conditions in IF function in Google Sheets

I'm using Google Sheets and I have this issue: is there any way to save the logical condition in the IF function into a cell? For example, we have this function:

=IF(B1>0; "Positive"; "Negative")

Could I in some way save condition 'B1>0' into a cell A1 and use like so:

=IF(A1; "Positive"; "Negative")

Obviously I can't do it like that because A1 is not a bool value. Is there any way to convert it into bool or save that condition in any other way?

Thanks in advance

Aucun commentaire:

Enregistrer un commentaire