Need Numbers Inputted and Deleted

rebel123

Active Member
Joined
Apr 18, 2017
Messages
345
Office Version
  1. 365
Platform
  1. MacOS
Thanks for your help.
Not sure if there is even an = equation for this. Please see attachment.
If there is a solution, please respond with =

So, most likely, the correct answer will start with =D5 or will at least include = and D5 somewhere
in the equation. I need a drag-down formula.

Thanks!
 

Attachments

  • Screen Shot 2021-03-02 at 1.38.19 PM.jpg
    Screen Shot 2021-03-02 at 1.38.19 PM.jpg
    116.2 KB · Views: 13

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.
What exactly is your question?
 
Upvote 0
The correct answers are in Yellow BUT how do i make a formula for that?
 
Upvote 0
It would be helpful if you clearly define the rules for the conversion.
Otherwise, we would be forced to make assumptions based on the sample data, that may not always hold true.
 
Upvote 0
Yes but it says... will start with =D5 so therefore it's easy to assume where the answers lie... Thanks!
 
Upvote 0
Yes but it says... will start with =D5 so therefore it's easy to assume where the answers lie... Thanks!
Hmmm... I still don't think it is clear what you are after.
Based on your comment in reply number 3, I was assuming that you want to take the values in column C, and convert them to what is shown in column D.
Is that not the case?

If that is what you are trying to do, I don't want to make any assumptions. Especially since the rules for the last entry appear to be very different than the first three.

Make it easy for us to help you by being thorough and clear what you are after!
 
Upvote 0
Gotcha. Sounds like drama. I have not heard any answers. Thanks!
 
Upvote 0
Yes, but the admin already said there are at least 2 different answers out of the 3...
 
Upvote 0
@jtakw
The 2nd of those has already been closed by me & the 1st one is (IMO) sufficiently different to this question.
 
Upvote 0

Forum statistics

Threads
1,213,482
Messages
6,113,913
Members
448,532
Latest member
9Kimo3

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top