Setting a sale price and rounding up

C

Chris

I have a wigit that's say $119. I want to take 15% off of that price and then
round up to nearest dollar amount.
 
A

Anthony

hi,

If the price for ur wigit is held in cell A1 (ie $119)
in B1 place =A1*(1-15%) - this takes off the 15%
in C1 place =ROUND(B2,0) - this round the number
not sure how to combine the two entries, but they will give youi the
required result
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

rounding a number up to a certain ending digit 6
Mail Merge Switch - Dollars to Words 0
Word VBA - Automatic change content of a cell in table using dropdown list 5
Divide a # into 3 #'s rounded to a whole # 9
Mail Merge Help 1
Consolidation Table from Different Excel Tabs with Different Format 1
Rounding up to next dime 2
Rounding Time to Nearest 5 Minutes 1

Top