Jan 12 2022 03:46 PM
Hello, Good night,
I'm trying to create a if situation, there's multiple PVC sockets, and for example a 90º knee, the person will choose the size of the socket and will receive the value automatic, for a example:
So i tried:
=IFS(C3=15;1,1;20;1,2;25;1,5;32;2;40;3,2;50;3,4;60;3,7;75;3,9;100;4,3;125;4,9;150;5,6)
The problem is, only the first two ifs return the propers values, if i choose 25, ill continue returning 1,2, 150 = 1,2, not 5,6.
My excel is a 360, and i tried in the Google version too, both had the same issue, if you have a more easy way to create this situation, i'm happy to hear you.
Thanks
Jan 12 2022 04:47 PM
SolutionJan 12 2022 04:47 PM
Solution