ok, excel boffins at the ready
taskey
Registered Posts: 1,800 Beyond epic contributor 🧙♂️
right please bear with me on this, i am good on excel, but this is maybe beyond me
i have a table with standard charges on it. i want to enter a letter for the charge and it will automatically pick up the amount and change it for me. i also want it to work out if i change the number of days to be below 15 it does not charge - mmmm. stumped!!
the data to be picked up is on another sheet within the same book.
i can email to someone if they want to have a look at it for me, i cant attach it for some reason.
might be something really silly i am over looking.
thanks in advance
Tracy
i have a table with standard charges on it. i want to enter a letter for the charge and it will automatically pick up the amount and change it for me. i also want it to work out if i change the number of days to be below 15 it does not charge - mmmm. stumped!!
the data to be picked up is on another sheet within the same book.
i can email to someone if they want to have a look at it for me, i cant attach it for some reason.
might be something really silly i am over looking.
thanks in advance
Tracy
0
Comments
-
sent you a pm drop me an email with the details.0
-
I'd use the sumif function, its handy I use it for all sorts of things.0
-
i have emailed it over to slakda, i have tried all sorts, it is probably staring at me in the face
we will see
thanks
Tracy0 -
done me thinks, Some multple if statements with vlookups tied into the equations should have sorted it.
Oh and sumif is the best function eva!0 -
i knew someone would resuce me from my misery lol
Thanks again
Tracy0
Categories
- All Categories
- 1.2K Books to buy and sell
- 2.3K General discussion
- 12.5K For AAT students
- 318 NEW! Qualifications 2022
- 161 General Qualifications 2022 discussion
- 11 AAT Level 2 Certificate in Accounting
- 56 AAT Level 3 Diploma in Accounting
- 87 AAT Level 4 Diploma in Professional Accounting
- 8.8K For accounting professionals
- 23 coronavirus (Covid-19)
- 272 VAT
- 92 Software
- 273 Tax
- 135 Bookkeeping
- 7.2K General accounting discussion
- 200 AAT member discussion
- 3.8K For everyone
- 38 AAT news and announcements
- 345 Feedback for AAT
- 2.8K Chat and off-topic discussion
- 582 Job postings
- 16 Who can benefit from AAT?
- 36 Where can AAT take me?
- 42 Getting started with AAT
- 26 Finding an AAT training provider
- 48 Distance learning and other ways to study AAT
- 25 Apprenticeships
- 66 AAT membership