• Happy holidays, folks! Thanks to each and every one of you for being part of the Tom's Guiide community!

Excel Formula

Forum discussion tagged with Excel Formula.
  1. W

    Excel Help MINIFS

    Hello you wonderful people, I am a bit stuck on an excel formula if someone could help me out it would be much appreciated. I need a way to calculate the min and max for each product, as I do with the average formula (=AVERAGEIFS(E:E,B:B,B3,C:C,C3,D:D,D3) (=AVERAGEIFS("Value...
  2. B

    Excel formula for tracking ticket sales in increments of 25

    I need to keep track of 3200 raffle tickets. I want to list them in increments of 25, then record WHO got which NUMBERED ticket. Beginning at 0001-0025, cell A1 0026-0050, cell A2 all the way to 3200 How do I do this?
  3. indyitguy

    Excel Function question

    Is there a way excel will recognize the value of [=A1&A2&A3] as a function? Example: Cell A1 is = Cell A2 is 'Sheet1' Cell A3 is !B3 Cell A4 is =A1&A2&A3 That would make Cell A4 produce ='Sheet1'!B3 so shouldn't it actually equal what is in cell B3 on Sheet1?
  4. GOM3RPLY3R

    Making a new Excel Formula?

    Hello all, I am working on a school project in which I have created a formula to calculate a score for the performance of a graphics card. It is as follows: p= peformance t=temperature c=clock I want to input this into excel and just use it as a shortcut instead of having to do...
  5. C

    Excel Formula

    I am trying to keep track of gas money that my friend owes me for driving to and from college. I would like to create a dynamic formula that applies to all the cells in my excel spread sheet and as you enter a number into one cell that applies to the amount of miles driven it then calculates...
  6. M

    Excel formula help needed

    Hello, I'm in need of an Excel expert, or just someone who knows better than I do how to put a formula together! I am trying to create a forumla to use with conditional formatting. What i need it to do is highlight a cell if two cells meet a certain condition. For example; IF G1 = "S73"...