Hello
I have a list of WHSL prices with 10% discount. What formula can I run to get the original price?
The algebra would be x*.9=(cell value)
Thanks!
Hi all,
I need a bit of help.
I have managed to make myself a invoice system for my small shop using Excel (quite a feat for me as I have very little experience with Excel). I have a stock sheet, customer details page, a log page and the invoice page which is populated from the other pages. The stock page has a macro that seeks out stock with a quantity over of 1 or more and then copies that info into the invoice.
Overall I am very happy with it, but I have one major issue I am struggling to overcome.
I give certain customers discount of either 5% or 10%, but this does not apply to all of the products I sell. So the issue I have is apply a 5% or 10% discount to only the product in my invoice that are entitled to it and not to the others automatically.
I am using XP and Excel2000
Can anyone help?
Need Help- I have lost my hard drive, that why I chose the name "LAMEBRAIN". I had a invoice form that I got somewere several years ago. I belive it is a EXCEL format. Anyway I have been able to copy a free invoice back that calculates total and so on . However there was a section on my old invoice called "Payment Details". It was a simple list that allowed me to click on a CIRLE or BULLET and a solid black dot would appear in the circle. I would like to add this to my Invoice.
There are also boxes on this old form with a solid line but there are RADII in the corners.
Payment Details
0 Cash
0 Check
0 Credit Card
Name
CC#xxxx xxxx xxxx 1234
Like this with box around and Payment Details shown within the top line of the box ----Payment Details----
Thanks,
Lamebrain
Hi
Here is my stumper. I have a sheet where the user enters a recurring monthly charge "Assessments", and late fees and the sheet calculates the interest on the Assessments and shows a running balance.
My problem is that I need to adjust the interest after the user enters a partial payment. Example: User enters three months of assessments (Jan. - Mar.) for $100.00 each and three late fees for $25.00 each. Then, in March, the user enters a partial payment of $100.00. I need to have the sheet apply it to the interest first, then the late fees and whatever is left to the oldest assessment (Jan.). Since that oldest assessment (Jan.)or a portion of it would still remain outstanding, the sheet should recalculate the interest on the new Jan. balance until the Jan. assessment is paid at which time it would no longer calculate interest for Jan.
I hope I explained that so it can be understandable.
I would appreciate your help.
Thanks
Adrian
I am analyzing a portfolio of loans. I set up my spreadsheet to run an amortization schedule for a sample loan, but what I am finding is that the loans have varying dates of when they were issued - 6/3/10; 3/18/09, etc, at all times of the month.
I am trying to create a spreadsheet that calculates the schedule correctly. If the loan is issued with a 5% interest rate, $25,000 initial amount, Start Date, 3/18/09, term: 180 months, how to handle this first months payment, and does it extend 180 months after the end of the first month???
HELP.
Hi,
I am looking for some suggestions on how can I possibly withdraw main data from my Invoice template (like: Invoice number, Name of the customer, total amount) in to another spreadsheet in order for me to create some sort of data base of every invoice that I send to my customers. I also wonder if some how I can auto increase my invoice number? For example if you open new invoice with number 001 so that the second one that you open will be automatically changed on 002 and so on, but with question If you reopen an existing invoice the number should not increase then.
I know that VBA can help but since I do not know anything about VBA I am looking for some help here.
Thanks in advance
When entering a formula for a mortgage payment the formula displays a
negative number. How do I get it to display a positive number for the
monthly payment.
Hi all!
I have a loan from my father which I need some help calculating. Hopefully, some of the experts in here can give me a hand
What I'm looking for is something which will let me enter the day the money was lent (there are several smaller amounts), and calculate these including interest and interest on the interest. Then, I will pay back in several steps, this debt but I would like to subtract the paid amount on the day it's registered and then stop acumulating interest. The last step is to show the outstanding debt.
I guess the payments and the calculation of interest could be done by some sort of nested, re-iterating function...?...
If someone could help me with this I would be REALLY grateful :D
Cheers!
Anyone have a link to a site, or can explain how to do DF and NPV in Excel?
I saw a demo but have forgotten!
Only very basic for a few years.
Thanks
