I need to know the function that anything =,< than 20 miles do not to do anything in Column C. And Any Miles >20 to show the result of miles >20 miles in column C. It should look like this. I have a couple hundered rows of this.[TABLE="width: 500"]
<tbody>[TR]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[/TR]
[TR]
[TD]Company
[/TD]
[TD]Miles
[/TD]
[TD]Excess Miles
[/TD]
[/TR]
[TR]
[TD]ABC
[/TD]
[TD]45
[/TD]
[TD]25
[/TD]
[/TR]
</tbody>[/TABLE]
<tbody>[TR]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[/TR]
[TR]
[TD]Company
[/TD]
[TD]Miles
[/TD]
[TD]Excess Miles
[/TD]
[/TR]
[TR]
[TD]ABC
[/TD]
[TD]45
[/TD]
[TD]25
[/TD]
[/TR]
</tbody>[/TABLE]