Search results

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...

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...

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...

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

..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...

Hi, I'm trying to find a formula that will only calculate if the data in an adjacent cell is greater that 0 and if not, the cell will remain blank. I'm not sure if I'm going about it in the right way, but I came up with: =IF(C8<0,(C8*1.175),""), but the cell remains blank no matter what I...

Hi, I want to create a formula to calcualate to calculate the percentage of yes's compared to no's in a table. The closest thing i could find was =countif(a1:a10,"yes")/counta(a1:a10) or =countif(a1:a10,"yes")/10 but there could be a different number of results recorded and I only want...