chelseywhite
New Member
- Joined
- Nov 16, 2022
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
Hi all,
My excel lists clients, how much they were billed, and what state they live in. Each state is paid at a different percentage (Ex: TX=32.5%, IL=21% ect.). I am trying to create a column that will calculate the Anticipated Collections based on the state.
My excel lists clients, how much they were billed, and what state they live in. Each state is paid at a different percentage (Ex: TX=32.5%, IL=21% ect.). I am trying to create a column that will calculate the Anticipated Collections based on the state.