Donate SIGN UP

funkylad20

41 to 60 of 160

First Previous 1 2 3 4 5 6 Next Last

Avatar Image
funkylad20

Excel IF formula with two logical tests?

Hello... Does anyopne know how I can say 'if A1 says 'Yes' AND B1 says 100, then the value if true will be 'Incorrect', value if false will be 'Correct'? I know about 'IF', but not sure how to work it...
09:54 Mon 05th Sep 201118 answers, last by ChuckFickens 13:49 Mon 05th Sep 2011
Avatar Image
funkylad20

Excel and Adding 6 Months to a Date

If I have 'June 2011' in cell C1, what will be the formula to add 6 months to this date to read as 'November 2011'?
13:10 Thu 25th Aug 20114 answers, last by funkylad20 15:53 Thu 25th Aug 2011
Avatar Image
funkylad20

Mortgage repayments and additional charges

I have recently completed a Transfer of Equity on our mortgage, of which the lender has charged a fee of £150, which they are adding to the overall loan. Does anybody know how I can work out the...
12:13 Mon 08th Aug 20118 answers, last by funkylad20 18:56 Wed 10th Aug 2011
Avatar Image
funkylad20

Excel Date and Highlighting to be Red line

If I have some data in a line, and there is a date field, how can I get the line to highlight as red if it is BEFORE today's date? I understand it is Conditional Formatting, but cannot seem to get the...
08:06 Tue 09th Aug 201113 answers, last by funkylad20 10:06 Tue 09th Aug 2011
Avatar Image
funkylad20

Same Sex relationship and Moving to Australia

I am in a long term same sex relationship, that is not legally recongised (i.e. not civil partner). My partner is potentially going to be moving to Australia with work (he is a professional Quantity...
12:53 Wed 03rd Aug 20115 answers, last by Hazel104 15:44 Wed 03rd Aug 2011
Avatar Image
funkylad20

Excel IF Formaulas, again

I always foget this how to do this one... How do I dsiplay the result of one cell if another cell has 4 options? i.e. cell A1 can contain either 1,2,3 or 4. If it contains a 2, the result in B1 should...
15:56 Mon 11th Jul 20118 answers, last by ZebUK 10:15 Tue 12th Jul 2011
Avatar Image
funkylad20

Excel lookup

I have a questionnaire with 17 questions. The answer for each question is one of the following; 'very satisfied', 'satisfied', 'neither satisfied nor dissatisfied', 'dissatisfied', 'very dissatisfied'...
16:03 Wed 25th May 20117 answers, last by Maidup 09:22 Thu 26th May 2011
Avatar Image
funkylad20

Mortgage Advice - rip off?!

We bought a house as a trio 3.5 years ago, for £225k. Obviously house values have dropped, but fortunately not as much for us as some areas. I bought one housemate out last year and recently my...
12:26 Wed 04th May 20115 answers, last by triggerhippy 13:03 Wed 04th May 2011
Avatar Image
yelenots

Renting in Leicester?

My daughter has just got a job for when she finishes uni in the summer and will need somewhere to rent preferably furnished.......can anyone recommend any agents that we can contact? Thanks :)...
17:56 Mon 25th Apr 201111 answers, last by daffy654 07:11 Wed 04th May 2011
Avatar Image
funkylad20

Drop down boxes on website wont load

Can anyone explain to me why arrow drop down boxes on wesbites will not work on my PC? I am running Internet Explorer 9 on Windows 7, on a PC. I can click the arrow, but nothing drops down. I imagine...
10:00 Thu 21st Apr 20112 answers, last by funkylad20 10:12 Thu 21st Apr 2011
Avatar Image
funkylad20

Excel IF and OR formula

I have a cell. This cell contains the value 0. Another cell contains the number 10. Another the number 20. I want to writ e formula that says: If the number is 15 and over, return the word ABOVE, if...
11:38 Mon 14th Mar 20115 answers, last by automation_man 01:50 Sun 20th Mar 2011
Avatar Image
funkylad20

London Appartments

Does anyone know where I could find a reasonably priced central London appartment for four days (3 nights) in April? Looking around the Bloomsbury / West End area...
21:32 Fri 04th Mar 20113 answers, last by funkylad20 16:56 Mon 07th Mar 2011
Avatar Image
funkylad20

Merging from Excel to Outlook - email Message

I am wanting to send an email to a list of people I have stored in Excel. I understand how to mail merge, but I cannot seem to enter a 'merge field' in the subject line of each email. To simplyfy and...
15:55 Tue 01st Mar 20112 answers, last by funkylad20 16:11 Tue 01st Mar 2011
Avatar Image
funkylad20

Excel Date Format

Does anyone know how I can change a DATE in excel to the 5-digit NUMBER reference? I have tried format cell, number, number and general...does not work!
09:14 Fri 01st Oct 20107 answers, last by ABerrant 12:54 Fri 01st Oct 2010
Avatar Image
funkylad20

Excel Graphs - a challenging one!

OK, here is a chalenging one...does anyone know what type of graph that will show the volume of something, making it appear relative to the scope a result is grouped into? So, I have a list of results...
14:18 Tue 06th Jul 20103 answers, last by funkylad20 08:19 Thu 08th Jul 2010
Avatar Image
funkylad20

Old film with a wolf attacking a man in the wilderness...

Does anyone remember a dark film that I vaguely recall watching when I was younger; there is a man in it, there are wolves, I remember a broken/infected leg from the wolf attack... and that is about...
11:10 Mon 07th Jun 201013 answers, last by karenmac60 21:56 Mon 07th Jun 2010
Avatar Image
funkylad20

Wolf head...rotating head...house fire...burning room...

Does anyone remember a 5.10pm BBC1 kids TV programme with a wolf in a cloak at the beginning, with blacked out screen and the wolf/man's head rotating menacingly? Also, vaguely recall a burning house...
11:12 Mon 07th Jun 20103 answers, last by beastmonkey 09:31 Wed 09th Jun 2010
Avatar Image
funkylad20

Excel Conditional Formatting to identify Different Postcodes

I have two lists of postcodes (column A and column B) The majority of entries are identical (i.e. A1 and B1 are the same) On occasion the 'B' postcode will be different to the 'A' postcode. HOW do I...
08:27 Fri 30th Apr 20103 answers, last by TTG 11:33 Fri 30th Apr 2010
Avatar Image
funkylad20

Art Print jpeg or PDF

I am desperatly trying to obtain a jpeg or PDF in a resolution of at least 150dpi of Salvador Dali's 'Reminiscene archeologique de lAngelus' - does anybody have any ideas? It is to get it large-scale...
09:41 Thu 29th Apr 20103 answers, last by Hymie 21:35 Sat 01st May 2010
Avatar Image
funkylad20

VLOOKUP in Excel

I have a list of numbers (Unique Reference Numbers) and attached to each URN is an email address. I have typed a VLOOKUP to pull through email addresses from one sheet to another. It pulls through...
13:42 Thu 04th Mar 20104 answers, last by dundurn 16:51 Thu 04th Mar 2010

41 to 60 of 160

First Previous 1 2 3 4 5 6 Next Last