Apr 16 2018 07:25 AM
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
Apr 16 2018 07:39 AM
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
Apr 16 2018 08:08 AM
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