Hello there, new to this forum. I've been looking for help like crazy so hopefully one of you can help me out.
I'm creating a sheet for work where several people will be inputting different data.
For this formula, cell A will have different letters from A to Y, but half of those will have a value of 1, the other half a value of 2.
Then this value will be multiplied by the ammount in cell B2 for example $10.
How does one achieve this?
Thank you in advance.
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
Click the * Add Reputation button in the lower left hand corner of this post to say thanks.
Don't forget to mark this thread SOLVED by going to the "Thread Tools" drop down list above your first post and choosing solved.
If you have, say, all letters from M down = 1 and all letters N and up = 2, this could be achieved by using something like...
=your-value*if(CODE(LOWER(A1))<=109,1,2)
If the value assignment is random, maybe create a small lookup table and use vlookup?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks