• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. T

    Multiplying times by hours in multiple spreadsheets not calculating [SOLVED]

    Hello, I have (what I think is) a complicated spreadsheet (link below) in which on the Daily Living Assistance Charges tab is the legend of charges. On the Calculation Sheet tab you will see that 15 minutes has been entered & totals to $64.58 as a minimum weekly cost. This also reflect the...
  2. T

    If's with dates times

    Hello I have a spreadsheet in which I have a report & it's due date & time. N21 is the due by date P21 is the time it is due by R21 is the date the report was received T21 is the time that it was received I would like my formula to return either yes or no if the report was received by the...
  3. T

    Pie Chart calculations

    Hi there! I have a bit of a problem that I can't seem to work out & I'm hoping that you can help me as you usually do.... The pie chart in Question 7 does not calculate correctly. If I put a 1 in the "Don't know" box the chart returns as "poor"...
  4. T

    multiplying hours and minutes by dollars

    Hi! I have a bit of a sticky problem... On my worksheet I need to calculate billing hours by a dollar value. My formula works fine when my billing is above one hour, however when it is below one hour it doesn't calculate. I have attached my file for reference...
  5. T

    percentages countif counta

    Hi, I'm attaching my workbook firstly as this may make more sense to you. I have a survey of a village that has 82 units. 28 of the 82 returned their surveys. Firstly, I think the data in the pie chart is correct. I'm not sure. I may be wrong (maths isn't my strong point). Secondly, when I...
  6. T

    IF cell has formula in it already to return blank

    Hi, I need a cell to calculate the difference between today and another date. The cell that has the other date in it already has a formula in it & returns #VALUE! They are as follows: =IF(ISBLANK(H11)," ",H11+21) - This is correct. I want this cell to add another 21 days onto a date...
  7. T

    continuing formula hundreds of times

    Hi, i am working on a database spreadsheet and would like help with formulas. I have a set of formulas in a box above and what I'd like to do is when I insert a new row I'd like the formulas above it to continue in the rows below. I'd like to continue inserting rows below into their hundreds...
  8. T

    nested if function with dates

    ok. So I have a spreadsheet & I'm creating a database. It has a date at the top of the page in "long date" format. Which would be today's date. At the beginning of the row it has another date in "short date" - the date that the enquiry is taken. It has data validation dropdown lists at the...
Back
Top