Forum Discussion

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

 

Can anybody help me with that?

Ifs function

2 Replies

  • Twifoo's avatar
    Twifoo
    Silver Contributor
    Mar 14, 2019
    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))
  • SergeiBaklan's avatar
    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

     

Resources