cell analysis

  1. H

    Check a cells value

    i am trying to solve a scenario.... A1=332.345 B1=331.658 C1=331.229 D1 should give output as 1 provided Condition1: A1>B1 AND C1<B1 Condition2: Neither of A1, B1 & C1 should be <=0. If any of abv 2 conditions are not met then D1=0. What formula needs to be punched in D1? Thnx in adv.
  2. D

    Figuring out what contents are in a cell

    I'm making a schedule for school. The school website will give me an excel document of all the games and practices put in. I download the list and then paste it into a formatting page that will then link to all the other scheduling formats and needs I have. The time's of the practices come...
  3. T

    Advanced Min-Max in Access

    Hi, I am looking at the transfering the following code from Excel VBA to Access VBA and was wondering if anybody could help me by telling me which factors I should look out for/ how I should change the code so as to make it functional. What the code does is to take an interval in a set of...
  4. B

    excel beta 2010

    Is there a way to split a numerical value of a single cell into each integer of it's value and list them separately in individual cells? For example: 391 is the value in cell A:1 and I want cells B:1, C:1, and D:1 to read 3,9,1 respectively, so I can derive at 13 in cell E:1: which is the sum of...

Watch MrExcel Video

This Week's Hot Topics

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
Top