Forum Discussion
Solved
Issue - SI(CHERCHE)
Dear all, I am having an issue in an excel file regarding the function IF(SEARCH). I need to use three of the fuctions in the same cell, but it only works for the first line. Here is the ...
=SI(ESTNUM(CHERCHE("JULIAN";A3));0,4;SI(ESTNUM(CHERCHE("LADY";A3));0,7;SI(ESTNUM(CHERCHE("LESLIE";A3));0,9)))
You can try this formula.
=SI(ESTNUM(CHERCHE("JULIAN";A3));0,4;SI(ESTNUM(CHERCHE("LADY";A3));0,7;SI(ESTNUM(CHERCHE("LESLIE";A3));0,9)))
You can try this formula.
OliverScheurich It worked !! Thanks so much.