+ Reply to Thread
Results 1 to 1 of 1

Entering a % or a number value and returning a result

  1. #1
    Registered User
    Join Date
    05-18-2012
    Location
    North Carolilna
    MS-Off Ver
    Excel 2007
    Posts
    20

    Entering a % or a number value and returning a result

    We have an online salary planning tool that isn't currently used by our entire organization. They have asked me to come up with a spreadsheet that has the same functionality as the tool which allows users to enter either a % or a $ amount for a salary increase and automatically calculates the other based on the input field. Where if Joe is making 10,000 and they type 5 in the % field the Amount filed populates with $500 and vice versa if they type $500 in the amt field, 5% populates in the % field. I can't figure out how to do this in excel because if they enter into the % field it would erase my formula. Reading over this I'm not sure I've explained it well enough, but I've attached my starting spreadsheet. I have the field set so you can enter a % and it will calculate the other fields, but that's as far as I've been able to get. I thought about putting formulas in hidden cells, but I'm not sure if that really how to do that and have the resulting amount show in a different field, if that's even possible.

    Any assistance is always appreciated!
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1