Search results for query: *

Hi I have a set of spreadsheets all of which have calculation fields on them. I need to pose the following question on sheet 5 =IF(Sheet4!L11=1,"=",0) Cell L11 on Sheet 4 is calculated from figures calculated on Sheet 3 which in turn are calculated from figures on Sheet 2. At the moment I...

Hi Am sure I've seen something somewhere which will help! I want to have a formula which says something like: if(A1=between15and22,1,0) i.e. if cell A1 has a value between 15 and 22 then put 1 otherwise 0 Anyone know what I need to do. Thanks

Hi Is it possible to put more than one 'if' factor in one formula. My current formula says =IF(J84=0,"due",0) but I also want the cell to return zero if cell G84=0.

Help! I have a list of members (complete with details such as address, tel number etc) on sheet 1. Sheet 2 is a membership form. each member has a unique membership number. I want to physically type the membership number at the top of Sheet 2 and all the details are automatically transferred...

Hi Just doing a timesheet/invoice for a client - managed to get a total of 52:20 hours for the week - but now need to be able to multiply it by, say, £30/hour. Obviously I need something more than =A5*B6 as this definitely gives me the wrong answer! Can anyone help?

Hi Just doing a timesheet which gives total hours spent in a week - then adds the weekly hours to give total for the month. Needless to say this ends up at over 24 hours - that's more than one day so it gives the wrong answer. I've formatted the 'time' cells as hh:mm - guess maybe that's...

Hi Had lots of problems with my laptop recently - lots of things disappeared! I have an ICC (think that translates as International Colour Code?) for my Epsom printer running on Artainium ink. Until the problems if I was printing to the Epsom all I had to do was click on 'profile to profile'...

Hi I use CorelDraw 12. I have managed to 'lose' the ability to use the transformation key? Specifically I want to have the ability to have a menu at the side of my screen (is this called a docker?) which I can leave open while I am working on a document. I need to rotate the image but even...

Hi I have just switched to Excel 2003 and find that for some reason once I have typed a formula into a cell I can't seem to change it. When I alter the formula Excel then just displays the formula itself rather than the solution. I figure I must have one of the settings wrong but cant figure...

Hi I need to fill several different shapes with the same text, in two separate formats 1. One or two words repeated over and over again until it fills the shape, i.e. Congratulations filling an entire square or oblong (hopefully without me needing to retype it enough times to fill it!!)...

Hi I have two different printers which are set up and used for a variety of purposes. I want (if possible) to save my files with the correct printer setting saved with it rather than having to change it each time. Is this possible? i.e. File one - printer 1 set for A5 mirror image File...

Hi I'm new to this programme but pretty excited! I have used Clone and Blur and a few others before. Unfortunately a friend borrowed my computer and I think he must have changed the settings? Now when I use the clone tool it just does nothing, likewise with the blur and other tools - its as...

Hi I'm building a dbase which will eventually run a catalogue (I hope!). Each item has a picture to show what it looks like. Can I store the pictures in the dbase, or do I reference it somehow, or.....? As you may be able to tell - I'm pretty new to Access. Any help would be appreciated...

=IF(OR(K17=L17,K17=M17,K17=N17,K17=O17,K17=P17,L17=M17,L17=N17,L17=O17,L17=P17,M17=N17,M17=O17,M17=P17,N17=P17),"Wrong","OK") The above formula is meant to discover whetgher any 4 out of 6 columns has the same value. i.e. if 'Collie' is in column K17 as well as L17 it will...

Hi Does anyone know how to create a mirror image in Adobe? i.e. if the subject of a photo is facing right - is it possible to turn it round so they are facing left? Many thanks Doreen

Hi I'm a complete beginner at Adobe - so treat me gently, please! I have several photos of dogs. I need to extract the dog and get rid of all the background. So far I've used the magic wand to highlight either all the parts of the dog, or all the parts of the background - then deleted what I...

Hi! I have an Access 2000 Dbase. One of the tables stores: Team (TRN), Tournament ID (TID) Fastest Time (Time) A second table shows amongst other things: Tournament ID (TID) Tournament Date (Tdate) I need to be able to run a query which: (a) Shows only the times for each team over the...

Hi I have a spread sheet which is intended to calculate the fastest team times at any one show. I've used the 'min' and 'max' commands. Now I want to get Excel to tell me what the fastest and slowest times are for the team overall. Again I've used the 'min' command. i.e. =min(C6:C500) I...

Hi I'm operating Outlook from Office 2000 on Windows XP. I recently installed a new version of Norton AntiVirus on my machine. I have now noticed that although I attach a file to an email the attachment doesn't arrive. Apparently the email has a 'paperclip' showing but it can't be...

Hi I have an Access 2000 Database which holds (amongst other things) the number of points earned by each member of a number of different teams. Somehow I need to be able to take the top 4 point earning members of a team, add their points together and show the total against the team. Each team...