In practice: an order form
AdvancedExpert
10 questions, about 22 minutes
Build a form that fetches the price by itself and works out the VAT.
What we'll do
- Looking up on another sheet
- Catching error messages
- Working out VAT
What you'll use
IFERRORVLOOKUPROUND
How it works
In an example you watch and don't need to fill anything in. You answer a question yourself. If it goes wrong, you get a tip, then a hint and finally the solution.
2examplesYou watch
10questionsYou do it yourself