IFS formula returning a #N/A error

Copper Contributor

Hello everybody,

 

I am working on a spreadsheet and need to return a value for tree different contiditons. the formula is as follows: =IFS(K356<=K358, 0, K358<K356<=K359, K362, K359<K358, K363) when I populate the cells included in this forumla the result I get is #N/A . I ran the troubleshooting and says that a value is not available for the formula or function, but all the values are there. I have been struggling with it over the weekend. Can anybody please tell me what I might be doing wrong? Thank you

2 Replies

I just solved it. I had to separate this argument  K358<K356<=K359, K362  in two different IFS, like this:  K356>K358, K362, K356<=K359,K362

 

 

Hi Juan,

 

Glad to hear that the issue has been solved!

But you can simplify the formula and combine it as follows:

=IFS(K356<=K358, 0, OR(K356<K358,K356<=K359), K362, K359<K358, K363)

 

Hope that helps

Haytham