Google calculator cost different to spread sheet

[jonespandrew]

Good afternoon



I am trying to get excel spread sheet and formula to match the cost of an item that I am creating a price list for.



I know the cost of a unit is £1080.35 as this is the cost we have been given. Google also says this when I type in the figures, however, excel keeps giving me a different figure.



Example if you type into google, 1271-15% you will get 1080.35. However my spread sheet is giving me 1080.30. I need the spread sheet to Match.



Current price 1,271.00

15% discount

Total to us should be 1080.35 not 1080.30



Copy of formula used below

Discount​	New Price to us​
0.15​	=D5*(1-E5)

 

[MARK858]

Works fine for me, are you sure that your cell contains exactly 1271?

Book1.xlsb
	A	B
1	1271	0.15
2
3	1080.35	1080.35
Sheet1

Cell Formulas
Range	Formula
A3	A3	=A1-(A1*B1)
B3	B3	=A1*(1-B1)

 

[jonespandrew]

Hi Mark please see my attempt below

List price 01/05/2022 is formated as currency amd so is list price 3/10/2022. Discount is formated as percentage with two decimal places. New price is formate as the same.

 

[MARK858]

It doesn't matter what the format is as it is only how it appears to the user (like putting a filter on a picture), what matters is the underlying value. Format your List price and List price +6% cells as number and set the decimal places to 15. What do you see? do this as well with the 1271 in your first post.

Please can you also use the boards XL2BB addin to post your tables as
a) we can copy the data into Excel rather than us retyping your data
b) it often will show us the real underlying value
c) we can see the column letters and row numbers (use the mini sheet option)

 

[jonespandrew]

Hi there i think i have solved it. i just need some advise on the following

in date of last price change column, i need a formulae to enter today's date if the our price to us column increase or decrease. value. This will be subject to the price increase box we enter a + or a minus percentage figure, can this be done..

in English it would read something like this.

if price increase/decrease percentage is blank then run in price to us exting formula, else run current list price+ percentage increase/decrease to give new price to us cost.
Date of change will then populate the date to which the price to us has changed.

Hope this make sense

 

[MARK858]

This is a different question to the original post, please start a new thread