Forum Discussion

Copper Contributor

Mar 14, 2019

IF Function

Hi I am trying to set up a document, that uses ifs function. It should look in a cell and write the number, if there is any. If there isn't any it should look in another cell and so on. I ha...

Ifs function

SergeiBaklan

Diamond Contributor

Mar 14, 2019

Hi,

IFS checks conditions one by one till finds first TRUE. Thus you may use it like

=IFS(A1,A1,B1,B1,...,TRUE,"")

taking into account you have only numbers or nothing in your cells and what any non-zero number is equivalent of TRUE