phoenix
phoenixPhoenix - Your AI Assistant
Inactive session will be ended in 24 hours
End Session

VBA Macro Modification for Excel Price Rounding Automation

  • Posted:
  • Proposals: 16
  • Remote
  • #4468078
  • OPPORTUNITY
  • Open for Proposals
Bisma I.Rostyslav V.Sarim I.Jagadish N.OLUWATOSIN I. + 11 others have already sent a proposal.
  • 3

Description

Experience Level: Expert
I have an Excel file with a list of prices.
There is a macro - button in the file that recalculates prices after entering a USD exchange rate.

Task:

Implement correct automatic price rounding logic inside the Excel file

Rounding rules:

Prices with 3 digits should round to whole numbers
Example: 102.21 - 110

Prices with 4 or more digits should round to hundreds
Example: 9189.29 - 9200

The rounding must be applied automatically when the button is pressed and should not require manual edits.

Requirements:

Strong Excel skills

Experience with formulas and automated calculations

Attention to numerical accuracy

I am attaching an Excel spreadsheet for your review

New Proposal

Login to your account and send a proposal now to get this project.

Log in

Clarification Board Ask a Question

  • Eight Veer Ltd

    Hi Bhavanshu, could you please confirm:
    1. Confirm the rounding method: do you mean nearest (e.g., 102.21 → 100) or always up (e.g., 102.21 → 110) for 3-digit prices, and similarly for 4+ digits (nearest hundred vs always up)?
    2. Which cells/range(s) should be rounded (all price cells, specific columns, multiple sheets), and should we ignore blanks/text?
    3. Should the macro overwrite values, or write rounded results to a separate column while keeping originals?

  • Dharma Raj K.

    Hello, Can you please attach your excel file?

  • Marimar H.

    Hi Bhavanshu,
    Could you confirm which column holds the prices that need the rounding logic?
    Do you want the macro to update only visible rows, or the whole sheet every time the button runs?
    Thanks.

  • Zoltan L.

    The attached file is not an Excel file. It is an Excel Addin which was compiled into C++ code from a source code. This file can not be edited or modified in any way without having the source code.

    Therefore, this project can't be completed as it has been announced.

    I recommend you to create a real Excel workbook containing your data, and explain in great detail how the data should be processed. Then I can write a real VBA script for you that will perform the rounding task as you requested.