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!
Write a formula that calculates the Annual Percentage Interest Cost of the Discount not taken for any set of data. Can anyone help with this please?
Thank you
Uli
Hi
I want to know the function to calculate the SI and the CI in Excel. I know manually we calculate the Simple Interest = P*R*T and compound Interest = P(1+i)^n . When I calculate the SI using inbuilt function of Excel i.e. PMT as shown in the following link
http://www.ehow.com/how_4813646_calc...est-excel.html
It given right answer. But if on same data i apply P*R*T it gives something different. Also I saw following site
http://www.busysoftorder.com/npv/1.htm
it uses FV function. Kindly advice how to calculate the Si and CI using inbuilt functions. I just want to calculate it when there is no change in the rate of interest in the subsequent years and it will remain same.
Regards
Harbinder Singh
61.48-61.42=0.0599999999999952
Why?
This happens frequently in various formulas.
66555.54-66081.35=474.189999999988
What is going on? Surely I'm not the only one that has noticed this?
I was trying to figure out a simple percentage using Excel 2007, and I'm a little confused.
A1=35
A2=45
A3=A1/(A1+A2)
The value of A3 displays as 0.
Well, I just about solved my problem because I've done similar formulae to get the answer of .4375. And now even the exact formula in different cells to get that answer.
Maybe it seems silly to still post, but can someone tell me why A3 continues to give me "0" after entering the formula different ways multiple times? Is this cell possessed by Satan?
I have a bunch of numbers in a table, all starting from row 6 and forward. Now I should put
Code:
Number in column X * TIMES * Number in column BH
and put that number in column Z. I could always just specify each cell in column X to be something like this:
Code:
=X6*BH6
but putting that manually into each cell, changing the row numbers and all would take forever. Therefore, could anybody supply me with some quick macro or formula or something (I really don't have a clue) to do this for me? Thanks!
Code:
=SUM((Q158:Q163)+(Q166:Q171)+(Q174:Q179)+(Q182:Q187)+(Q190:Q195)+(Q198:Q203)+(Q210,Q211))
What is wrong with this formula? It returns a value of, well, #VALUE!
Don't Laugh. I just need to know how to force a value in a textbox to increase by a set amount when I click on a button. I know this code is not right but it will give you the idea of what I want to do.
Private Sub CommandButton10K_Click()
Me.TextBoxMileageValue.Value Plus 10000
End Sub
When I click the CommandButton10K I just want the value in the TextBoxMileageValue to increase by 10,000
How do I do that?
Thanks Jody
I am trying to add percentage numbers and it is rounding up/down...Is there
any way to stop the rounding.
example
CELL C36 CELL D36 CELL E36
ACTUAL # =C36*(1-20%) =C36*(1-80%)
$169.82 $135.86 $33.96
$775.81 $620.65 $155.16
$945.63 $756.50 $189.13
WHEN I USE A BASIC ADDITION DOWN EACH COLUMN, I GET NUMBERS ROUNDED DOWN IN
COLUMN D AND NUMBERS ROUNDING UP IN COLUMN E. IS THERE ANY WAY TO GET THE
ACTUAL NUMBER.
THANK YOU
G14: $1500.39 - Total Due
G16: =(G14/2) - 50% Deposit
G18: =(G16-G14) - Balance Remaining
When G14 is an even number - no prob. However, when it's an odd number as
above:
G16: = $750.20
G18: = $750.20
How can I get this to balance properly? (G16: $750.20 and G18: $750.19)
