Hi, can you help me with this please?
Use the IFS function to return 5 if cell A5 contains the value 3, and return a 6 if it contains any other number
Hi, can you help me with this please?
Use the IFS function to return 5 if cell A5 contains the value 3, and return a 6 if it contains any other number
What do you want otherwise?
e.g.
A5=3 --> 5
A5=100 --> 6
A5=0 --> ???
A5=blank --> ???
A5=text --> ???
As a starting point you have =IFS(A5=3,5,ISNUMBER(A5),6) but I guess you want to deal with other input values.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks