Profit - Rounding

[The Animal]

Hi Crew
This is my first visit
I am creating a price list so need to add a 30% profit to known costs but want the selling price to always round up to $0.20 ie $10.15 - $10.20 etc.
Thanks Stephen

[meyero90]

Hello and Welcome,
try this: for the basic formula
=ROUND(number,1)

However, I would guess since I don't have your numbers based on your spreadsheet that it has to be combined with the following:
=ROUND(number*1.3,1)

multiplying by 1.3 which of course represents your 30% profit increase and combining it with ROUND formula will end up with your expected result

[DonkeyOte]

You can use CEILING

=CEILING(cost*1.3,0.20)

[TMS]

Assuming the cost price is in A2:

Please Login or Register  to view this content.

Regards

[The Animal]

Thanks for such a fast reply as my first time a little unsure of what to include so say
Product cost in A1 ($22.50) and selling in B1 (with 30% added and rounded up $0.20) formula would be??
Thanks

[DonkeyOte]

Are you rounding up to nearest multiple of 0.20 (see post #3) or rounding up to nearest integer.20 ?

[meyero90]

Look at the attached spreadsheet formula is in B2

[DonkeyOte]

meyero90 - I'm not sure how that fulfils either of the possibilities

To round up cost + 30% to nearest multiple of 0.20

=CEILING(A1*1.3,0.2)

To round up cost + 30% to the next integer.20

=INT((A1*1.3)-0.21)+1.2

[meyero90]

I am sure but I think that The Animal means when the value is 10.15 to round it up at the 2nd decimal which gives 10.2. But will need confirmation from him.