• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel Retail Margin Calculator - advice required... [SOLVED]

A

andrewp7

New Member
Hi all,


I'm building a calculator for retailers to use in Excel that will handle four variables:


- sell price $

- cost price $

- margin %

- gross margin $


The brief requires that when ANY two of the variables are entered, the remaining two will calculate.


QUESTION: Currently researching different ways of doing this task and was wondering if anyone had any advice on how best to build this tool?


- I need to keep the front end very simple as user Excel skill set will vary widely.

- Prefer no macros as it will be used on many different computers.

- Needs to run on different versions of Excel at least 2007+, maybe even 2003?


I welcome any ideas & appreciate you taking a moment to reply.


Many thanks


Andrew
 
Hi Andrew ,


Can you check the file here ?


https://www.dropbox.com/s/kszvyy65etyrf18/Andrew_Example.xlsx


The IFERROR function is not available in Excel 2003 and earlier , but the formulae can be revised using the ISERROR function.


Narayan
 
Narayan - I'm speechless! Thank YOU so much for taking the time to do that - I didn't expect the work done for me but it is much appreciated.


I'll have a play & let you know if I have any questions.


Andrew
 
You must log in or register to reply here.
Back
Top