Home

IF Function

LauraExcel
Occasional Visitor

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 Replies

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

 

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))
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies