Need Numbers Inputted and Deleted

rebel123

Active Member
Joined
Apr 18, 2017
Messages
347
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
Just to clarify - is the issue that you are not getting the correct result, or that it is showing the formula and not a calculated value?
If the issue is that you are seeing the formula and not the calculated value, that means that your cells are pre-formatted to be "Text".
Change the format of the cell to "General", and re-enter the formula, and you will see the result of the formula instead of the formula itself.
 
Upvote 0

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.
gotcha tried that and it also did not work...https://filebin.net/d7utbnzld81sbk7s
 
Upvote 0
that is the file if you could download it in and fill in the orange ones and then i can paste the equations here
 
Upvote 0
When I do it..... this is what i get...the results are in orange
 
Upvote 0
Screenshot
 

Attachments

  • Screen Shot 2021-03-03 at 7.44.33 AM-min.jpg
    Screen Shot 2021-03-03 at 7.44.33 AM-min.jpg
    251.6 KB · Views: 3
Upvote 0
There appear to be way to many possible formats.
Without a complete explanation of the logic we need to use to get the correct values, I cannot help you any further.
 
Upvote 0
Solution

Forum statistics

Threads
1,214,942
Messages
6,122,366
Members
449,080
Latest member
Armadillos

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