Forum Discussion
IFS formula returning a #N/A error
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) wh...
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
