# Posts by dodger7

• ## Formula for comparing totals?

Re: Formula for comparing totals?

thats cool mate if it is only going to be one higher or lower than 16, but if its say for example 5 higher than 16, it will just say +1

any ideas?

cheers

• ## inactive sheet?

Re: inactive sheet?

sorted, cheers mate

• ## Formula for comparing totals?

Re: Formula for comparing totals?

what would the formula be though? im not too hot with formulas - the real data i have is 5,2.5,2.75,0.5,0,0.25,0,1,1,2,1 and i want to know if its more or less than 16 - which I could just count, but im doing 65 rows, so will jsut copy the formula

cheers

• ## inactive sheet?

Hi,

I have a spreadsheet with formulas in it, but everytime I make a change to figures i have to go into the formula cell and hit enter, as its not picking up the changes automatically like it normally does. does anyone know how to make this automatic again?

thanks

• ## Formula for comparing totals?

Hi,

Im looking for a formula for the following:

I have a row of figures, and want a formula to enable the chosen cell to tell me if its plus or minus a certian number - for example, i have a row with numbers 5, 4, 3, 4, and i want to know whether its more, less or equall to 15, the cell chosen would say "+1", or if I was wanting to know if it was more, equall or less than 20, it would say "-4"

thanks very much for any help, much appreciated

• ## Cannot Hide sheets

Re: Cannot Hide sheets

another possible reason could be that, if you are at work like me, your system administrator can disable the function. (my macro has bee ndisabled by my system administrator for some strange reason!!)

Jamie

• ## Format cells...

Re: Format cells...

magic, cheers mate

• ## Format cells...

Re: Format cells...

cheers Alan, solves my problem.

Another question I dont know if this is even possible. My Spreadsheet is full of formulas, and I need them removed (programme I use at work dosnt accept the sheet if there is formulas in the background) but I still need the text in the cells to remain the same as the formulas would give. Is this possible?

• ## Format cells...

Please help! This is probably easy for you guys, not me!
I have a spreadsheet with National Insurance Numbers in one column, and I need the format code for 'custom' when you go into format cells to remove the last digit automatically. for example, if the NI Number was AB123456C, I need the formula to automatically remove the 'C'

thank you! :thanx:

cheers bud

thanks mate

• ## formala for copying a date into another cell but backdated 6 weeks?

does anyone know the formula to: copy a date from one cell to another but backdating it 6 weeks? for example, I put 01/06/04 in C2, and the formula puts 20/08/04 in D2?