JonesL

A Sanyo projector we have is in a fixed mount on the ceiling and has all of a sudden been turning on and projecting as if it's been moved back half a meter or so. The image is far too large for the screen but the projector hasn't been moved. I adjusted the resolution and positioning but once the projector had been turned off, the settings had reset. As far as I've read elsewhere, the resolution settings are supposed to be saved therefore should not reset once the projector has been switched off. Has anybody else experienced this problem with Sanyo projectors and know how to fix it?

I have a spreadsheet where I have an IF function in one of the columns. The type of IF function is dependent upon whether the entrants are Male or Female, as they have different sports results. Can I use a VLOOKUP function to enter the correct IF function into the specified cell when either 'Male' or 'Female' is typed into another cell? If so, my IF functions have specified cells in them (obviously for IF it contains a certain number, display this text) so what can I put instead of specific cell numbers that will get the correct ones each time? I hope this makes sense!

I have the following function in a series of cells: =IF(J41>=2000,"Outstanding",IF(J41>=1900,"Above Average",IF(J41>=1600,"Average",IF(J41>=1500,"Below Average",IF(J41<1500,"Poor",""))))) However if cell J41 is blank, it still returns "Poor" whereas I'd like it to stay blank until a number is entered. I've tried using an ISBLANK function at the end (replacing the value if false instead of the "") but cannot seem to find what it should be. Can anybody help? Thanks

Thank you for your response Norphy. You're dead right the problem is that my laptop is capable of 3200 x 1800 but on the 15" screen it is really small. In Windows 8.1 there are several opportunities to increase font size but this only seems to be for menus, application headers etc. but we still find some applications have fixed font size in their dialog boxes and things like windows messages and even the apps menu in windows 8.1 have small fonts. This size can be set but the options are either large or small, when set on small it is virtually unreadable on my screen. I think this is simply a combination of high resolution on a small screen size that Microsoft have not thought about.

I have a Dell XPS with 15.6" screen. The resolution is set to 3200 x 1800 which is the recommended size, however the text seems to be tiny even when it is set to 'larger'. I have changed settings within the desktop which has increased the size of the text but only for certain text areas. For example, in Outlook the ribbon text is large but the message content and message pane has stayed quite small. The text is readable but seems to small to be the largest setting I can possibly choose. I also have a surface and I compared the app name text on my surface to my laptop and the text size is exactly the same! Surely with the larger resolution on my Dell it would make the text slightly larger? Please don't ask me to only change the settings in desktop as this will only apply to the desktop and not the whole device. Another issue I'm having is in each of the browsers, the writing is tiny and this is when the zoom is on 100% so I don't expect to have to zoom in when my eye-sight is perfectly fine! It wastes the space of the screen as its all tiny in the middle! Please help.

When trying to print a Word document containing labels from one PC to one of our printers, the document comes out as though the table hasn't been recognised so the text is all at the top of the page (there are no gaps underneath each label) so obviously the labels can't be used as the text is spread across two labels. However, this isn't anything to do with the document as the document I was trying to print is on a shared network drive so when trying to print from another PC to the same printer, they printed out perfectly. I've tried updating the driver and editing the registry using regedit and the "HandleNestedLayoutWithinTableCell" DWORD but this has had no effect whatsoever. I think this is a problem across any printer that we try and send it to also. Any ideas?