What formula should I use to find the details in the cell?
Put this in B2 and copy down to B13:
=IF(ISERROR(FIND("Manager",A2)),C2*$F$2,C2*$F$3)
Yeah, I put this, but it came out opposite, i mean like the answer should be
in true statement, then it came out answer of false statement, and for the
false statement, it came out true statement, how come?
|