Hi
I am trying to have this formula working with one more criteria. Not sure why I am stuck:, initially this is working
=IFERROR(IF(LEN(VLOOKUP(C4;'Sheet2'!H:BD;5;FALSE))=0;0;VLOOKUP(C4;'Sheet 2'!H:BD;5;FALSE)/100);0)
But I need to add one more criteria, if vlookup returns >100, if true it should show 100 otherwise the rest of the formula above.
it is one more IF criteria to be inserted in the 3rd part of the formula above, theoritically like that but its not working
=IFERROR(IF(LEN(VLOOKUP(C4;'Sheet2'!H:BD;5;FALSE))=0;0;IF(VLOOKUP(C4;'Sheet 2'!H:BD;5;FALSE)/100>100;100;VLOOKUP(C4;'Sheet 2'!H:BD;5;FALSE)/100);0)
I am trying to have this formula working with one more criteria. Not sure why I am stuck:, initially this is working
=IFERROR(IF(LEN(VLOOKUP(C4;'Sheet2'!H:BD;5;FALSE))=0;0;VLOOKUP(C4;'Sheet 2'!H:BD;5;FALSE)/100);0)
But I need to add one more criteria, if vlookup returns >100, if true it should show 100 otherwise the rest of the formula above.
it is one more IF criteria to be inserted in the 3rd part of the formula above, theoritically like that but its not working
=IFERROR(IF(LEN(VLOOKUP(C4;'Sheet2'!H:BD;5;FALSE))=0;0;IF(VLOOKUP(C4;'Sheet 2'!H:BD;5;FALSE)/100>100;100;VLOOKUP(C4;'Sheet 2'!H:BD;5;FALSE)/100);0)