I have tried everything I can think of and read all the posts but I am still
at a loss. I am trying to make a formula that would insert the value of cell
E4 if in cells F4 through J4 have S/O in it. When I did the IF formula it
would put in the cell the number in front of the cell with s/o in it instead
of the value in E4. Please help!