whole number

  1. T

    Whole Numbers

    In my use of formulas when calculating numbers from a live data feed. Negative numbers are important, however I am looking for a method to remove the polarity of a number and have it represented as a whole positive number regardless if it was previously negative? Can some one help? Thanks
  2. E

    sum of only whole numbers in a column.

    I am using Numbers on my Mac. I want to add a range of all cells, but not include any negative values. I was thinking sumifs, but not sure how it works, or if that is the way to do it. please help. Sorry, I know this is simple. I did a quick search, but didn’t find anything.
  3. S

    Counting using raitios and combining Remainders

    I love excel and use it for all my business needs ive recently made a very large workbook with many calculations and they all work the way i want. save for one section! i for the life of me cannot get this to calculate correctly. please help me! here is what i am attempting i need to count...
  4. D

    Extracting Minutes from Time

    Hi all I have a cell (say A1) that contains data (in HH:MM) format. What I would like to do in the next cell (A2) I would like to extract the minute part of A1 but have it in a normal number format so for eg 01:41 would just show as 41 in cell A2. I can do it by just changing the number...
  5. M

    Applying Comma style, but having whole numbers have zero decimal points

    I'm trying to figure out how to format a group of cells where comma style is applied, but if the number is whole it has zero decimal places. I don't understand the excel code very well I don't know how to do this off the top of my head. I'm sure it's very easy, but any help is greatly appreciated!
  6. C

    Solver Scenario for Optimal Whole Number w/Office97

    Every time I think I know what I'm doing with Excel Solver - I surprise myself (by what I apparently don't understand . . .). I'm trying to solve for the maximum number of company store "certificates" I need to buy, up to say a maximum of $600, in order to buy the maximum number of movie...
  7. A

    Mathematical problem-ROUND function doesn't help

    I have an annual sales target of no. of units to be sold which is to be divided quarterly. My historical sales data gives me the ratios in which the annual target is to be divided into quarters, the ratios are 0.17, 0.23, 0.3 and 0.3 respectively for Q1,Q2,Q3 and Q4. When I divide the target...
  8. F

    Assigning dollar amounts to numbers for inventory

    Hello all, I am creating an inventory sheet and am stuck on the waste category. It is obviously easier to count the waste as whole units, but I would like to assign dollar amounts to each unit in each cell, individually. For instance, for hamburger buns($.33) lost, arbitrarily I would put 40...
  9. H

    Removing whole number to leave decimal

    Is there a way that I can remove the whole number to leave the decimal place. 1.69 should be 0.69 10.71 should be 0.71 0.48 should be 0.48

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top