Hi all, im newbie here, i need your help to create a formula on (T30) with condition
<tbody>
[TD="class: votecell"][/TD]
[TD="class: postcell"] 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)
[/TD]
</tbody>
<tbody>
[TD="class: votecell"][/TD]
[TD="class: postcell"] 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)
[/TD]
</tbody>