Hi all, im newbie here, i need your help to create a formula on (T30) with condition
<tbody>
</tbody>
IF (Q30)=(H30)OR(Q30)>(H30)AND(S30)=3 OR (S30)>3 then (T30) will be A IF (Q30)=(H30)OR(Q30)<(H30)AND(S30)=1 OR (S30)<3 then (T30) will be B IF (Q30)=(H30)OR(Q30)>(H30)OR(Q30)<(H30)AND(S30)=0 then (T30) will be C IF (Q30)=(H30)OR(Q30)>(H30)AND(S30)=-1 OR (S30)=-2 then (T30) will be -A IF (Q30)=(H30)OR(Q30)<(H30)AND(S30)=-3 then (T30) will be -B IF (Q30)=(H30)OR(Q30)>(H30)OR(Q30)<(H30)AND(S30)>-3 then (T30) will be -C Note Q30 = Saving Cost (Format Cells as Price) H30 = Supplier Cost (Format Cells as Price) S30 = Date Achieved (Format Cells as Number) T30 = Supplier Performance (Format Cells as General) |
<tbody>
</tbody>