Formula

Page 2 - Forum discussion tagged with Formula.
  1. Christopher Chung

    Change Word/Excel Pie Chart Total

    How can I change a pie charts total? Each piece totaling 500 instead of 100. I tried adding a formula on each cell but it's still taking it out of 100. Thanks
  2. J

    Giuve me some c++ code for here

    Prob 1: Accept dollar value and print the equivalent peso value. The program will convert dollar to peso having an exchange rate of 1 to 43.35 Prob.2 Create a program that will accept a temperature in Fahrenheit and print its equivalent temperature in Celsius. The formula for converting...
  3. gamerxavier

    Converting decimals to time formula needed

    trying to find a formula on converting decimals to time. I'm making a spreadsheet for a game >..> and i am trying to manage something. say i have this.. 7.72=days I need a formula for google docs to convert that into the actual time.
  4. S

    Simple spreadsheet maths

    Hello people, what's the formula I'd enter for LibreOffice Calc (or Excel etc) to return the lowest/highest numeric value on a row/column/selection? Thanks :-)
  5. M

    How to format a formula with a percent that will not result in a negative number

    I have a spread sheet in which the formula uses a Precentage to calculate values , however I want to exclude any negative numbers and also numbers over 100. What element do I add to the formula to obtain this desired result? Thanks
  6. E

    {JAVA} Calculating PI without using class.math

    Is it possible to calculate the Number PI without using the java class math? I found this formula to calculate PI. I think i need some int arrays to save the numbers but actually i'm stumped. Has anyone a hint?
  7. G

    Excel 2007 formulas

    Well i have a worksheet with 30 thousand rows and 3 columns. I need to use this formula =+A1:A27202&":"&B1:B27202&":"&C1:C27202 on each row,but i dont know how,and doing it by hand would be too much time consuming.When i select the D row and paste the formula it says 'Data on the clipboard is...
  8. E

    Excel - using a range (in one cell) in a formula

    Hello, I have a number of excel spreadsheets related to ticket sales that I'm trying to get organized. In one, we're keeping track of the actual ticket number (the one stamped on the ticket itself). Is there a way to use a range that's in one cell in a formula? For example, I have...
  9. nekulturny

    MS Access Question- Homework related -tearing my hair out!

    Working on a chapter assignment, I submitted last week. I couldn't make the formula work, professor gave it back to me with an extension as well as a formula to try and resubmit. Well using the formulas she gave me, I still can't make it work. Trying to get a simple record count from a sub...
  10. P

    how to unlock cpu,s with my crosshair formula V

    how to unlock cpu,s with my crosshair formula V
  11. P

    unlock my amd 560 be with crosshair formula V

    Hello, unlock my amd 560 be with crosshair formula V
  12. C

    Matching speaker wattages to a 100 w 3 way crossover

    Is there a rule of thumb or a formula to follow in selecting the speaker use wattage for each section in a 3 way crossover say that is 100 watts. How do they determine what wattage each speaker should be for the Low, mid, high in a 100 or 200 watt crossover?
  13. A

    Mr google com

    Hello, how to use countif formula in microsoft excel...??? can you tell and teach me..
  14. ulillillia

    Underwater darkening formula

    In the real world, things get darker as you get deeper underwater. I'm trying to replicate this in my game by darkening the entire scene and I need a formula (assume the middle of the ocean where the water is very clear). Relative to the surface, as a percentage, what is the formula for how...
  15. R

    How to lock a excel farmula

    need to know how to lock a formula in a excel worksheet
  16. G

    AI Help!

    hi! i got a formula that i don't quiet understand, coursework, can anyone help thanks, appreciate lots if you can help the formula and its descriptions are in a blog please check the link A Team! i also uploaded a image of the formula. info: There is a list of n items that are to be send...
  17. exfileme

    Gamers Far Worse Drivers than Non-Gamers

    Fans of Need For Speed and Formula 1 apparently suck at driving. Gamers Far Worse Drivers than Non-Gamers : Read more
  18. G

    Formulas

    I am working on a spreadsheet and need to create a formula so that in the following instances the cell is highlighted: If the date in cell A <= Today + 180 days AND The date in cell B <=A + 90 days. Then Cell 'A' will be highlighted. I am not sure if this is possible. Can anyone offer a...
  19. 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"...
  20. I

    Excel linking documents within formula help -- Suddenly not working

    I have been using Excel for many years and considered myself pretty sharp on Excel issues. Recently Office 2010 Startup was installed on this computer (and since has been removed). I have a rollup document that I link excel to in a formula situation. Before I could just go into the cell...