Formula Help

Copper Contributor

where is the error? 

=SE(B2="1"J5);(B2="2"J6);(B2="3"J7);(B2="4"J8)

presenting #ERROR!

2 Replies

@Vitor_Cassiano 

=SE(B2=1;J5;SE(B2=2;J6;SE(B2=3;J7;SE(B2=4;J8))))

Maybe with this formula.

@Vitor_Cassiano What type of function are you using with SE? if you can explain some context I could help.

 

John

https://www.excel-template.co.uk