Recent content by clintonmadden

  1. C

    Dynamic graph problem

    Hi Lemo, thanks for your reply. The formula you suggested did the job, thanks very much.
  2. C

    Dynamic graph problem

    Hi, I have been trying to create a dynamic graph that will update when data is entered into it. I found a good tutorial which works and have created a spreadsheet for displaying sickness. I now want to add in a trust target line of 3.25% to the bar chart but only want to display this for...
  3. C

    Calculate using the next available number

    Thanks for the information, I'll have a look when I get a second, I've been given a load of high priority work to do lol. But then whatever anyone gives me, it always seems to be high priority...more like work people don't want to do themselves lol
  4. C

    Calculate using the next available number

    Hi, I've been making a spreadsheet to show costs per division then taking the cost +VAT from the budget however the divisions aren't making their purchases in order and my spreadsheet returns a #VALUE! error. Is there a function I can use that will use the next available number in a column...
  5. C

    Do not calculate non numerical values

    OK I'm having a few problems putting the formula together. I wasn't sure how to use the ifna option so i was wondering if i could use the iferror function like this: From this =(D6+F6)/((D6/C6)+(F6/E6)) i get...
  6. C

    Do not calculate non numerical values

    Thanks for the help, I'll have a look at this later on today :)
  7. C

    Do not calculate non numerical values

    Complicated Formula - ISERROR function Hi, I have been working on a spreadsheet to calculate the total number of staff when given the number of staff on annual leave and the percentage of staff on leave for 2 subsections of total staff for each department but there can be occasions when the...
  8. C

    Display percentage mark, don't x100

    Hi, I was wondering if anyone could help me.. I have a chart in which I want the user to enter a number, and if they forget to put in a percentage mark, to display one without the result being x100 if there's data in the cell. Any help would be appreciated, Clinton
  9. C

    Divide by all values greater than a string of 0 length

    It's working perfectly! Thanks very much for your help. Clinton
  10. C

    Divide by all values greater than a string of 0 length

    Thanks for the reply, I'll give it a go!
  11. C

    Divide by all values greater than a string of 0 length

    ..or something like that.. Basically I have this formula: =IF('Delivery Suite'!K17+'Orchard Mat.'!K12+'Orchard Gynae'!K14+Riverbank!K10+Meadowbank!K13=0,"",'Delivery Suite'!K17+'Orchard Mat.'!K12+'Orchard Gynae'!K14+Riverbank!K10+Meadowbank!K13) So it's calculating the sum of the cells if...
  12. C

    If value is true, use a formula else display nothing.

    Lol, yes i guess it's good to have something to break up the day!
  13. C

    If value is true, use a formula else display nothing.

    Ah that's great, you're amazing thanks! Just wish I could add to your reputation again!! I'll have to remember that Isnumber function, it'll definitly come in handy again.
  14. C

    If value is true, use a formula else display nothing.

    I tried this equation but it still displays #VALUE! in the box instead of nothing. Any idea how I could do that? Thanks
  15. C

    If value is true, use a formula else display nothing.

    Ok, I've managed to attach it, I just had to delete the x from the .xlsx extension as it wouldn't let me upload it. I'm having problems with the remainder column, I need that to not display anything unless the condition is true and it performs the calculation, also I need the total box to work...
See more
Back
Top Bottom