Forum Discussion
IFS condition in another iFS
Hi, im kind of struggling writting an IFS into an IFS. I would like to calculte the number of sets, depending on : - if the cell C14 is equal to 0, 1 or 2 (0 for squat, 1 for bench, 2 for deadlif...
Sorry, but it's totally unclear, at least for me
I would like to calculte the number of sets
How do you calculate sun?
if the cell C14 is equal to 0, 1 or 2 (0 for squat, 1 for bench, 2 for deadlift, but it never works if i write text)
Where do you write text?
and depending the number in C14
What the dependence is ?
here is the formula that i used to calculate the number of sets, depending what you choose for recovery : =IFS(Settings!$D$19=1;1;Settings!$D$19=2;2;Settings!$D$19=3;3)
I see no summing here. Where this formula is ? By the way, on practice equivalent could be =Settings!$D$19
I think the IFS formula is going in cell F14 and based on the value of D14 it should look up the corresponding value in Settings!$D$17:$D$19. My first point is that D14 should be TEXT to match the TEXT in Settings!$C$17:$C$19 and then use XLOOKUP
=XLOOKUP(D14,Settings!$C$17:$C$19,Settings!$D$17:$D$19,"incorrect selection",0)
=XLOOKUP(D14,Settings!$C$17:$C$19,Settings!$D$17:$D$19,"incorrect selection",0)
- Hi, thanks for your reply.
I played with XLOOKUP, but i always end up with #error
