Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Rounding Currency up/dn

0

I have watched several of the videos and searched for an answer but I need help. This is my first time on the forum.

Is there a way to round a dollar amount to the nearest interger after multipling it by a percent? example I have a cell with this formula in it "C6+C6*I16" C6=$110.00 and I16=-7.5%

the answer is $101.75 and I would like to round these to the nearest whole number.

thanks for your help

excel
posted by: RonJ (rep: 2) on Thu Aug 22, 2019 at 6:43 pm
Answer
Discuss

Answers

0
Selected Answer

try 

=ROUND(<yourformula>,0)
posted by: k1w1sm (rep: 197) on Thu Aug 22, 2019 at 7:07 pm
Discuss

Discussion

Hello, thank you for the attempt but it installed into the cell with no error but it didnt execute the formula. Any other ideas?
RonJ (rep: 2) Aug 23, '19 at 7:34 am
It is just the ROUND() function - start typing =Round in Excel and it will help you fill-in the rest.
don (rep: 1989) Aug 23, '19 at 4:16 pm
Add to Discussion


Answer the Question

You must create an account to use the forum. Create an Account or Login