VermontFarm
New Member
- Joined
- Dec 11, 2015
- Messages
- 2
I want to embed an ‘isnumber’ within if/then statement to place the dollar value of a column into another column. Even though I can see the two characters I am looking for (VT), the formula continues to come up as “FALSE”, and I suspect it is because of the format of the cell that contains the text. Has anyone out there had the same trouble?
[TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="width: 395"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]VERMONT DMV SERVIC 802-229-4171 VT 05602 US[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]70.00[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I’m trying to pull all charges done within a specific state into another column so I can total those sales and verify sales tax charges.
[TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="width: 395"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]VERMONT DMV SERVIC 802-229-4171 VT 05602 US[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]70.00[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I’m trying to pull all charges done within a specific state into another column so I can total those sales and verify sales tax charges.