IF Function

[LauraExcel]

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 have five cells it should look in, before it should write 0 og nothing "" instead.

Can anybody help me with that?

[#2]

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

[#3]

If the 5 cells from which to look into are in A1:E1 and your formula cell is F1, the formula therein is:
=INDEX(A1:E1,
MATCH(1,
INDEX(—ISNUMBER(A1:E1),0),
1))