[TABLE="width: 500"]
<tbody>[TR]
[TD]weekly salary[/TD]
[TD]ee[/TD]
[TD]er[/TD]
[TD]weeks[/TD]
[TD]salary[/TD]
[/TR]
[TR]
[TD]200-339.99
[/TD]
[TD]11.9[/TD]
[TD]23.8[/TD]
[TD]4[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]340-449.99[/TD]
[TD]17.4[/TD]
[TD]34.8[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]450-609.99[/TD]
[TD]23.3[/TD]
[TD]46.6[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]610-759.99[/TD]
[TD]30.1[/TD]
[TD]60.2[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
hello
so i need aformula to say if my salary is 600 then use ee b3 also multiply ans by d1
<tbody>[TR]
[TD]weekly salary[/TD]
[TD]ee[/TD]
[TD]er[/TD]
[TD]weeks[/TD]
[TD]salary[/TD]
[/TR]
[TR]
[TD]200-339.99
[/TD]
[TD]11.9[/TD]
[TD]23.8[/TD]
[TD]4[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]340-449.99[/TD]
[TD]17.4[/TD]
[TD]34.8[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]450-609.99[/TD]
[TD]23.3[/TD]
[TD]46.6[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]610-759.99[/TD]
[TD]30.1[/TD]
[TD]60.2[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
hello
so i need aformula to say if my salary is 600 then use ee b3 also multiply ans by d1