Automatic Percentage Insertion

[chicagoro]

Column B in my spreadsheet is labeled Material. Column E
is Sales Tax. How can I set it up so that when I enter an
amount in Col B, a figure is automatically inserted in Col
E of the same row that is 8.75% of the Material cost? I
am using Office 2000 & Win 98.

 

[Andy B]

Hi

Try this:
=IF(B1<>0,B1*0.0875,"")