Search results

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

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

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

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

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

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

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

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

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

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

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

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.

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

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

Hi Guys, thanks for the replies, it worked perfectly. However there's another problem. I have another formula which I want to calculate and also display a blank if there is no value in the cell. But the cell in question is the one I have just made the equation for, which you said has inserted...

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

The original formula did work, I made a post just before vbaInet posted the second formula to mention the mistake I'd made. All working well now, thanks :)

Actually, ignore me I'm being an idiot today! lol I realised it is working correctly, but the result box was too small to display #DIV/0! so just showed #### so when I started testing the results it showed #### still. The problem was I had formatted the cells with the formula in to display...

I tried it on general and text but get the same result. Still has the #DIV/0! in the box. I noticed though if I choose all "no's" it correctly gives me 0%