jeudi 5 mars 2015

Google sheet, keyword to return the value of the parameter of the logical expression in IF Formula?

In IF statement is it possible to return the value of the parameter of the logical expression with some keywords instead of rewriting the parameter?


The reason is that for nested if statements it would be very useful.


I've tried to explain it as better as possible in English but I suppose that the best way is an example.


An example is:


This is using the parameter of the logical expression:



=IF('MySecondSheet'!C21>0, 'MySecondSheet'!C21, false)


This is the same but using an hypothetical keyword that I will call "this"



=IF('MySecondSheet'!C21>0, this, false)


Is it possible in some way?


Thanks,


Aucun commentaire:

Enregistrer un commentaire