Hello i have attached a screenshot with a formula i made but i want to simplify it because itl will be very long with no reason.
I want to cell I45 to have all the VAT of the cells of E multiplying with price per item of F and adding 13% VAT.
I will next copy it for 23% VAT
Now its working but if i add all the cells until No 43 it will be huge.
Can someone help me please.
Thanks in advance
invoice.jpg
Last edited by jimmmi; 01-14-2015 at 06:01 PM. Reason: wrong tittle
Ok just edited. Please confirm if it is ok
Last edited by jimmmi; 01-14-2015 at 06:04 PM.
It would be better if you uploaded the actual spreadsheet as it is difficult to see that is happening with a screen shot.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Ok thank you i will uploaded it.
How can i attached it?
I just want a SUM of all the sub calculations if it helps until i upload the file because i am on smartphone right now
Seeing the calculations will make it easier to supply you with a viable solution.
Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
Try:
Formula:
Please Login or Register to view this content.
By the way, my result is a little different to yours as you are omitting the first value in row 23 in your formula.
Dan
Don't forget to ☆ me if I helped you!
Hello thank you for replying.
The type you gave me gives me error and cannot be used. Do you know why?
Καλημέρα!
Pls check posts# 3 & 6.
This is the way to go.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Καλημερα! You mean the uploading? I understand but i will be in pc again this afternoon.I will upload it and also i will ask a few more things for some dropdown lists. Thanks
We'll be waiting for that!
Finally found solution Thank for helping guys!
It is always helpful to other forum members that you post your solution when not found on this site. In this manner, when others are searching for a similar problem, you will have helped them.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks