ryanrimsky
New Member
- Joined
- Apr 6, 2023
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
Hi,
I'm trying to relieve some stress and make our spreadsheets easier.
We have a weird process, so the payment method (Card, Direct Debit, Apple Pay, Bank Transfer, etc) determines where we put the gross value in.
Card and Apple pay payments go through as 'Card'.
Direct Debit and Bank Transfer go through as 'Bank'.
I want to add a formula to automatically calculate the VAT and NET from whichever cell is filled with the gross value.
Sorry if this is confusing or I haven't explained it too well.
I'm trying to relieve some stress and make our spreadsheets easier.
We have a weird process, so the payment method (Card, Direct Debit, Apple Pay, Bank Transfer, etc) determines where we put the gross value in.
Card and Apple pay payments go through as 'Card'.
Direct Debit and Bank Transfer go through as 'Bank'.
I want to add a formula to automatically calculate the VAT and NET from whichever cell is filled with the gross value.
Sorry if this is confusing or I haven't explained it too well.
Book1 | |||||||||
---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | |||
1 | Date | Payment Details | Payment Method | Bank | Card | VAT | Net | ||
2 | 06/04/2023 | Example 1 | Card | £ 100.00 | |||||
3 | 06/04/2023 | Example 2 | Direct Debit | £ 20.00 | |||||
4 | 07/04/2023 | Example 3 | Apple Pay | £ 50.00 | |||||
5 | 08/04/2023 | Example 4 | Bank Transfer | £ 200.00 | |||||
Sheet1 |