Over 1 million tech questions and answers.

IF and negative numbers

Q: IF and negative numbers

Hello. Please let me know how to make Excel work so that

IF
A1=B, then the number I put in is positive
A2=D, then the number I put in becomes negative automatically, in red font

Thanks.

RELEVANCY SCORE 200
Preferred Solution: IF and negative numbers

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

A: IF and negative numbers

Read other 16 answers
RELEVANCY SCORE 70

Is there a way in Excel to set up a column so that all numerical entries will automatically be negative numbers?
 

Read other answers
RELEVANCY SCORE 69.2

I'm using Quattro Pro12 in MS Excel Mode.

When I format a negative number as (1234.56) and save the spreadsheet, that format is lost when I open that spreadsheet again. The format reverts back to -1234.56.

What am I doing wrong? The ( ) format just won't stick!

Thanks.
 

Read other answers
RELEVANCY SCORE 69.2

I know by formatting the cell you can select negative numbers to appear in red. I was wondering if there was a way to do that with zeros?
 

A:Excel and negative numbers

Hi there,

Yes, there is, but you'll need to do a custom format as there are no default formats for showing anything equal to zero in red. Now in order to do this, you'll need to understand a little of custom formatting. There are four items you can specify, and they are in specific order: Greater than zero, less than zero, equal to zero, and textual values. These items, are separated by a semi-colon ( ; ). So something like this...
Code:
0.00;-0.00[Red];0.0[Blue];[Green]
This should explain them a little more...

http://office.microsoft.com/en-us/excel/HP051995001033.aspx
http://www.ozgrid.com/Excel/CustomFormats.htm
http://www.exceltip.com/st/Replacing_Zeros_with_Dashes_in_Number_Formatting/66.html

HTH
 

Read other 1 answers
RELEVANCY SCORE 69.2

I have an excel spreadsheet (2002) Someone has entered in all the numbers that are supposed to be negative numbers like this 14.56- when you try and add all the numbers all together it returns a zero value because excel doesn't understand that it is a negative number because the minus sign should be on the other side of the value.

Does anyone know of a good idea on how to get all the - signs on the other side of the number or any quick way to make excel understand these numbers as a negative eg -14.56????

Help!!!
 

A:Excel Negative Numbers

Read other 8 answers
RELEVANCY SCORE 68.4

I am trying to make a spreadsheet AGAIN. This is probably the 10th time in the past few years. I get so frustrated I just give up. I'm going to try to be a bit more persistent this time. I formated cells for numbers. I entered the amounts and then realized much later that the numbers should have been shown negative because they were a "cost" or out of pocket expense. I've tried to fix all the cells at once but I can't figure out how. So I have been doing one cell at a time which is FRUSTRATING. I also has other months that I will have to deal with this problem and was hoping you could help me figure out how to fix this. The following list shows the numbers I have changed to minus/negative. All the numbers below those minus numbers should also be negative. Do I have to do this one by one or is there a way to do it all at once?


Item Purch Price
HD shirt -$2.95
Danica Indy car shirt -$2.95
Steve Madden denim heels -$7.00
Mauve dress barn dress -$2.00
Brighton purse -$3.00
Silk spiegal dress -$2.00
HD shirt womans -$5.00
Ann Taylor clutch blue -$5.00
Napoli slip dress $2.00
Kate spade floppy hat $2.00
brown/white geometric dress $2.00
Blk/wht halter dress $2.00
C... Read more

A:Formating cells for negative numbers

Hi

Try this.
Save first to make sure we don't mess it up

This works if the values you want to change are all positive. It won't work for values that are already negative.

Select the cells that you want to make negative. Right click the selection and choose COPY.

In an empty column maybe next to the cells you selected if it is empty, right click a cell that you want to be the top cell in your list.

Choose PASTE SPECIAL

Under OPERATIONS click SUBTRACT

Click OK

That should make a column of negative versions of what you had selected. Then you can copy those and paste them over the positive numbers.

Hope this helps
James

Read other 4 answers
RELEVANCY SCORE 68.4

Greetings from Sydney, Australia.

In my last job we used Lotus and you could elect to show minus amounts with brackets around them. Now I have a new job and we use Excel 2000 that shows negative amounts with a minus sign, only. You can't change the format by using Format, Cells, Number.

How do I get negative amounts to show with brackets around them? Also, if this is possible, how do I nominate this feature as a default whenever I start a new Excel worksheet? For that matter, even if it isn't possible, how do I nominate any default options?

Thanks mate.
 

A:Excel - can't get brackets around negative numbers

Hi Lee,

You can make the changes you want by using Format - Cells - Number.

Just choose Custom andyou will see a scroll down list of possibilities. None of these include bracketing so you just have to add them yourself in the TYPE field.

For instance, make

#,##0.00;[Red]-#,##0.00

read as

(#,##0.00);[Red](-#,##0.00)

to get the result
(-78.98)
in your selected fields.
 

Read other 2 answers
RELEVANCY SCORE 68

First time posting...I am working on a spreadsheet for work in calculating a benefit. I have listed in C13 a minimum benefit (currently $25, but it varies). Later in the spreadsheet I subtract two numbers (c32-c33). If the number is less than zero, I have the formula put 0 in C34 as the answer IF(C32-C33<0,"0",(C32-C33)). That works fine. The problem is that later I when I want to list out what to pay, if the final answer is less than the minimum, I want the minimum to show, otherwise I want the calculated answer to show. Here is my formula. IF(C34<C13,C13,C47) Everything works great unless the original numbers subtracted is less that zero....for example $600 - $600 - the final results spits out the minimum of $25. Perfect. But when $600 - $601 = really equals -1, but I have it showing 0, the final answer spits out 0, not the $25 that I want. Any ideas on what to do to get it to put the C13 value instead of 0? Thanks so much for the assistance!
 

A:Solved: 2003 Excel Negative numbers

Read other 11 answers
RELEVANCY SCORE 68

My problem is with Excel 2002 and negative numbers. This version of excel does not have brackets for negative numbers in the "format" "cells" section of Excel. I have tried changing the currancy values in the regional settings, but with no luck. Has anyone seen this problem before? Some versions of XP do have it, while others don't. It is not restricting itself to either small business, professional or standard (XP) either. I have also applied all of the updates and service packs to office.

I have looked and saw that i can do a custom format, however, does this formatting apply itself to all sheets or just the sheet, or cells that you are working on?

I really wanted to apply this format to all sheets.

Thanks
 

A:Excel 2002 problem with negative numbers

Can you describe the format? Did you try creating a custom format.
 

Read other 2 answers
RELEVANCY SCORE 67.2

I changed the formula in column a source data worksheet so that it returns some negative numbers.

A pivot table using this data source, doesn't include these negative numbers in its sum total.

Not sure why its not included in the sum total.

If I highlight the entire column in the worksheet, the total does include these negative numbers.
 

A:Solved: Pivot table not summing negative numbers

Read other 11 answers
RELEVANCY SCORE 67.2

Hi

I am using office 2000 and windows 98. I just had it all re-installed and now when i open up an old spreadsheet it shows the negative numbers just with the minus sign infront of the number. Where as before all the negative numbers would automatically appear in Brackets.

Does anyone know how to change this back?
 

A:[SOLVED] Excel 2000 negative numbers in Brackets

Read other 7 answers
RELEVANCY SCORE 66.4

Hi All,

Have been searching round the internet for a while and cannot find the answer to my problem so thought I would join here see if anyone can help out??

I want to have a cell that states HW (for Home Win) D (for Draw) and AW (for Away Win) based on a points score in another cell, however cannot seem to get it to work for the draw based on a negative value.

Example 1

Home Team - Points Score 500
Away Team - Points Score 300
Diff - +200
Result - HW

Home Team - Points Score 500
Away Team - Points Score 490
Diff - +10
Result - D

Home Team - Points Score 490
Away Team - Points Score 500
Diff - -10
Result - D

Home Team - Points Score 300
Away Team - Points Score 500
Diff - -200
Result - AW

However, I want the range for the draw to be between -50 & 50 but cannot seem to get the nested IF function to return the negative number. The formula I have for home and away are;

IF=(K8>0;"HW";IF(K8<0;"AW"))

Which would work fine, I just cannot work out how to get the between -50 & +50 range that would return a result of "D" for the draw

You help is appreciated in advance
Thanks

 

A:Solved: Open Office Nested IF Function for Negative Numbers

Read other 6 answers
RELEVANCY SCORE 66.4

Hi All

I have a spreadsheet full of numbers formatted as currency. Some dollar amounts are positive and some are negative. I want all the negative numbers to be in red font. Instead of me searching for all the negative numbers (they are in the hundreds) and turning them all red manually, is there a simple macro that can do the trick? This will save me a lot of time. Since the numbers change from negative to positive and vice versa and the number of rows and columns also change, I'm having a hard time programming it.

Has anyone out there written a macro than can do this?

Thanks

Mario
 

A:Solved: Turning negative numbers to red font in an Excel spreadsheet

It's built into Excel - just highlight the cells, go to format cells.
Go to Currency. There are 2 boxes on the right - the lower one allows you to have negative numbers in parentheses ($3.00) or red $3.00 or a combination of those two or with a minus sign.
 

Read other 3 answers
RELEVANCY SCORE 45.2

Hey everybody.

I don't know if the title is a good one for this problem, but here goes.

I have a column that has numbers in this format: 54321-1234

Now, I want to take off the last 4 numbers, and the dash, from all the numbers in the column, using a formula. So that the output would be: 54321.

I want it so the first 5 numbers stay the same, but the dash and last 4 are gone. Is this possible?

Thanks.
 

A:Solved: Excel 2003: Replacing Large Numbers with Smaller Numbers

Read other 13 answers
RELEVANCY SCORE 44.8

This was asked before by KlausdB:

"I have 4 x HDDs on SATA AHCI (Intel Controller) in Native Mode and 1 x ESATA on Win 7 Pro X64.
I noted that looking in Admin. Tools\Computer Management\Storage (as an example) the 1st HDD (Port 0 in the AHCI BIOS) is showing as "Disk 2" instead of my expectation of


"Disk 1".
Selecting the Drive's Properties correctly shows the "Location 0 (Channel 0, Target 0, Lun 0)".
I also note that the Disk Number allocation in Windows will change randomly after some reboots/startups - going anywhere from "Disk 1" to "Disk 4".  I can force/replicate this


behaviour by removing the ESATA drive.
Is this expected behaviour?
It doesn't appear to create any operating issues at this stage, however, is there a way I can force the Drive to always map to (eg) Device 0 --> Disk 1, Device 1 --> Disk 2,


etc?
Thanks."


 This was answered by Nicholas Li:

"As far as I know, how the disk is plugged physically and the order it is displayed are not related. For a simple example, if a drive is plugged to SATA interface 4 and it is the only disk, it will be displayed as Disk 0. If there is no related issue about
the disk order, I think we can safely ignore this."


 Because the topic was closed I want to ask a new question here:
 What happens if one of the 4 HDD drives or 5 has an OS installed on it? I ask because windows always write some bo... Read more

Read other answers
RELEVANCY SCORE 44.4

I have three SATA hard drives :
Main system/boot drive , WD Caviar Black 1 TB, connected to the SATA 0 port
A backup drive, identical WD Caviar Black 1 TB, connected to the SATA 1 port
Another dirve, Hitachi 1 TB, connected to the SATA 2 port
When I installed Win 7, only the main drive was connected... and it remains the only drive with active/system/boot partitions.

QUESTION 1.
All three drives reporr correctly in the BIOS, and in the right order, but why is it that only one of the drive (the one on SATA port 1) has a "SATA:" prefix and the others have a "HDD:" prefix ?

QUESTION 2,
Why is it that the assignment of Disk #0, 1, 2 ( as seen in Disk Maanger or DiskPart) does not seem to have nay rhyme or reason?

I would have expected:

- the hardrive connected to SATA port O, to be assigned as Disk 0
- the hardrive connected to SATA port 1, to be assigned as Disk 1
- the hardrive connected to SATA port 2, to be assigned as Disk 2

but instead, I have:

- the hardrive connected to SATA port 2, is assigned as Disk 0
- the hardrive connected to SATA port 0, is assigned as Disk 1
- the hardrive connected to SATA port 1, is assigned as Disk 2

Just curious why that is.

I am assuming there is no way to chagne this. Its not something I would dream of reinstalling Windows 7 to correct ( even if it did correct it).

A:SATA port numbers vs assignemnt of Disk numbers/

Best advice, leave it alone. It may bother your (and others) sense of order but it won't affect how anything works, and no re-installing Windows won't change it.

Read other 9 answers
RELEVANCY SCORE 43.6

I have Windows XP, with Wordpad v5.1 and Notepad v5.1 as well. In Notepad, if I toggle off Word Wrap, I can then toggle on the Status Bar, and it shows me the line and column number in the status bar. It does not look like Wordpad has the ability to show line and column numbers. Does anyone know if there is a way to show that in Wordpad? Thanks.

Read other answers
RELEVANCY SCORE 43.6

I have been given four transcripts of telephone calls recorded at a call centre. All at different times on the same day. Two have the same callID number. The sequence of the numbers attributed to each call are odd. The first call has a higher number than later calls and the last two are also out of order. I am not sure if this is the right forum but i am desperate for some help. The transcripts are VERY important and I cannot be sure that they are the real deal because of the callID numbers. Any suggestions? Thank you in advance.
 

Read other answers
RELEVANCY SCORE 43.6

I was checking my program and software list and at the top of the list I noticed two (2) sets of numbers that I have never seen before. I checked the internet to see if I could find out what they were. It kept taking me to sites for spyware, adware,etc. I could not find out what they were or why they are on my system. I do not want to remove them until I know what they are. I have not noticed any problems with my system, but I do not know what might be going on behind the sceen. The numbers are listed as follows:
{684CB795-C157-4E15-93D4-E26015FEF1EA}

{F850707C-B6A0-4B56-8709-F89CF8F9AC6D}

ANY HELP?

A:Found Numbers Unknown Numbers In System

The first one > http://www.acresso.com/products/is/i...d-overview.htm

The second one > http://eraser.heidi.ie/

Both are legit and not malware.

Read other 1 answers
RELEVANCY SCORE 39.6

Hi,
I have some reference books I use and in all of them I have this problem:

The number written on the document pages doesn't match the number my pdf reader says, and for every document it has a different offset. That is, for example when I go to page 16, then on the page itself it's written that it's page 5 and not 16.

It's an annoying problem.
Is there any way to fix this by changing the pdf numbering or is there any workaround?

Thanks
 

A:pdf page numbers don’t match document page numbers

Read other 16 answers
RELEVANCY SCORE 39.2

Hi its been a while since i was on this part of the forum.

I was doing a pandascan a while ago. I wasnt expecting much on it. Preparing myself for just a few spyware maybe as it had been a while since i last scanned my computer. After a while however it picked up these 2 files as suspicious:

C:\documents and settings\ben\my documents\ati updates\dcprosetup_15.zip[dcprosetup.exe][DCleaner.exe]
C:\documents and settings\ben\my documents\DCProsetup_15\DCProSetup.exe[DCleaner.exe]

Now i thought that these were legit files? Could it be a mistake on pandas behalf or should i look into it more? What are your opinons on the matter?

P.S. Thats twice now my internets konked out while on BC.... Sound supcious? Should i go into safe mode and try a few tests?

A:Possible False Negative?

Use the program in the link below to remove the malware.http://www.malwarebytes.org/rogueremover.phpDescription of malware:http://spywarefiles.prevx.com/RRIHGJ294489/DCLEANER.EXE.html

Read other 5 answers
RELEVANCY SCORE 39.2

I'm downloading a decently large file (2.50 GB) and it's in the Negative percent, the download bar (little blue bars that go across) are all the way across, I have 160 MB of 2.50 GB downloaded, and it says 4 hours and 10 mins left, and it also says -11% as the percent complete, what does this mean??

Thanks ^.^
 

A:Negative % in download??

What it means is fairly straight forward. Of the huge download, only 11% has been downloaded and 11% of 2.5GB is about 160mb. It is estimated to take 4 hours to download such a large file. If you are on dial-up, it might take that long! On DSL or cable, it should not take that long. Does that answer your question?
 

Read other 2 answers
RELEVANCY SCORE 39.2

My new HP Envy x2 notebook screen inversed its colours. Now in a pdf- or word documents have white letters and black background. Also staring icons have black background. Everything was in order for two weeks, but suddenly this black and white problem was there. How to correct this?

A:Screen went negative

Hi, If recently use option #3 of the following link will help:    http://answers.microsoft.com/en-us/windows/forum/windows_7-pictures/laptop-screen-shows-negative-col... Regards.

Read other 5 answers
RELEVANCY SCORE 39.2

I am getting a negative effect on any picture i get on my computer. Either emailed, uploaded, downloaded etc. I currently am running windows 95, my computer is set at 32 bit color ( changed from 256( no effect on anything)). My desktop folders also have the negative effect. Can someone please help. Is this a resolution problem? Can this be fixed in safe mode? Dis i change the display to something it should not be at? help please. I have been trying to fix this for weeks.
 

A:negative effect

Is this perchance a Laptop?

"The negative effect" I assume you mean the colors are backwards, white is black, green is purple, etc, etc

If this is the case there should be a strange key on your keyboard that looks like a white A and a black A. Usually you hit the function key then hit the other reverse key to change the colors around.

Otherwise... you will need to find your video card settings and mess around with the gamma section majorly.

Cheers
Ryan
 

Read other 2 answers
RELEVANCY SCORE 39.2

Hi, I do not pretend that I have a serious problem with Windows 7 Home Premium 64-bit.
Every time I start my computer I get a low pitched negative sounding noise which repeats 2 or 3 times. It is a little annoying as I feel something is wrong. The only thing that has changed is when I connect my camera using USB Nothing appears on the screen so I take my memory card out of the camera and use the SD slot on my computer. I then get options as normal.
PS I have my settings to ask me every time.
Hoping you can Help
barri53
Tech Support Guy System Info Utility version 1.0.0.2
OS Version: Microsoft Windows 7 Home Premium, Service Pack 1, 64 bit
Processor: Intel(R) Core(TM)2 Quad CPU Q8300 @ 2.50GHz, Intel64 Family 6 Model 23 Stepping 10
Processor Count: 4
RAM: 3839 Mb
Graphics Card: NVIDIA GeForce 7100 / NVIDIA nForce 630i, 256 Mb
Hard Drives: C: Total - 297421 MB, Free - 216163 MB; D: Total - 297595 MB, Free - 155783 MB;
Motherboard: Packard Bell, MCP73PVT-PM
Antivirus: Norton 360 Premier Edition, Updated and Enabled
 

Read other answers
RELEVANCY SCORE 39.2

Hi Folks'...

Anyone got any good source for me to buy a negative scanner ?

I have a load of older film that I want to now digitise.

Any advice help would be grately appreciated please, thanks
 

A:Where can I get a negative scanner ?

Read other 9 answers
RELEVANCY SCORE 39.2

Any negative impacts. So have a go at gobbling up it in the wake of examining the underneath audit all things considered. slim foria fixings The real component settling utilized as a bit of this slim foria supplement is slim foria with a social affair of ..
 

Read other answers
RELEVANCY SCORE 38.8

Hi, so far i have managed to make my program so that it prints out the odd numbers between two inputted numbers but i need it to print the sum of them?
This is what i have:

public static void main(String[] args) {
int int1, int2, sum = 0;
Scanner scan = new Scanner(System.in);
System.out.println("Please enter two integers: " );
int1 = scan.nextInt();
int2 = scan.nextInt();
for (sum = int1; sum <= int2; sum++){
if ( sum %2 != 0 ){
System.out.println("" + sum);
}
}
}
}
 

A:Java: Sum of all odd numbers between two numbers?

Read other 9 answers
RELEVANCY SCORE 38.8

I use a very basic spreadsheet to work out my flexi-time each day. This works fine for positive numbers (ie. when I have worked my normal hours in a day) but when I have a negative amount (eg. when I have worked 10 mins less than my normal day) Excel displays ######## in place of the daily balance. Is there any way I can make Excel display the actual balance even when it is negative.

Thanks in advance.

Gogs
 

A:Negative Times in Excel

Read other 9 answers
RELEVANCY SCORE 38.8

hi , i seem to periodically run into this problem .

my digital camera takes movies in .mov format . when i go to view them in media player or quicktime they appear like over exposed colour negatives - lots of white , blue and yellow and no other colours . could someone tell me why this is and steer me to a solution please ?

thanks in advance
 

A:.mov file looks like colour negative !

bump
 

Read other 1 answers
RELEVANCY SCORE 38.8

Does anyone know if there is a slide/negative scanner adapter I can get for a Lexmark 5150 printer/scanner? If there is one, do you know where I can get it? I haven't been able to find one anywhere.
Thanks!
 

A:slide and negative scanner

Go to Porters.com they have a big selection of photo equipment.
 

Read other 3 answers
RELEVANCY SCORE 38.8

Is it possible to scan an old B & W negative and print it out in normal B & W colors? If so, how? TIA.
 

A:Scanning & Printing from old B & W negative

It can be done but your results will depend on what type of scanner you have and what graphics programs you have.
Plan to spend some time and go through some trial & error to get the finished product just right.
After your initial scan I suggest you work with copies of the original scan so you can always try again.
Tell us more about your hardware/software.
 

Read other 3 answers
RELEVANCY SCORE 38.8

LS,

When I'm receiving live-stream video the sound is OK.
The problem is, that I get the video in neg. colours...
My OS is Windows XP.
On my notebook (Windows Vista)everything works perfect.
What can I do to fix this ?

Kind regards,

Elzo
 

A:Solved: Negative colours

Read other 7 answers
RELEVANCY SCORE 38.8

Hey guys i need some help with my laptop. A month ago the LCD screen cracked inside and warranty would not cover is so I found a website and bought the LCD myself. i just installed it myself and I installed it correcctly and it all went well except now the screen is in negative picture, white is black and what not.

Is there something i can do to reset or calibrate the screen to have the colors corrected? or do i possibly have the wrong screen? The computer is a Sony Viao VPCEA24M

thanks in advanced for the help
 

A:New LCD displays negative color

Read other 6 answers
RELEVANCY SCORE 38.8

Help in converting B/W negatives into B/W positives, using Hp Scanjet5500c, HP Photosmart 7550 & Adobe Elements 2.
 

A:old black & white negative

hi there, what do you mean? YOU need help or you can help?
I found most photoprograms and digital imaging programs can change positive to negatives but none of any of my hardwares can do that.
 

Read other 3 answers
RELEVANCY SCORE 38.8

I just bought Otek FS-502 hoping to scan heaps of old 35mm negative, but I am rather disappointed in the quality of the images I am getting, they are wishy/washy (not sharp or clear). After I have transferred it onto my PC the dimensions are 2544 x 1696 but the size of the file is 500-600KB whereas my normal digital photos are 2-3MB, which I assume is the problem. Am I expecting too much of this Scanner or have I not set up the scanning process correctly? Or is it dependent on the SD card, I have tried a couple with same result.
Also another problem has emerged when I emailed a couple of photos (saved from my digital camera) as attachments to a friend; when I open up my sent message, at the top (above the addressee headings) there is a message "OA removed access to the following unsafe attachments in your mail IMG_795.JPG". so all I have is the hugely enlarged image in the email itself.
Hopefully you can understand my 2 problems/issues an have some easy resolution.

Many Thanks
 

A:Otek FS-502 negative scanner

Your unsharp scans are caused probably by you not setting a high enough scan resolution in your Otek's scanning software.
 

Read other 2 answers
RELEVANCY SCORE 38.8

I have a scanner for scanning film negatives which worked really well with Vista 32 bit but I have been unable to get it working with Windows 7 64 bit.

It is made by a company called Fujitac (who don't seem to have a website anymore) but it uses OVT Scanner drivers. Initially Win 7 didn't recognise it but after loading the drivers from the original CD it seems to be recogised. The driver version is Omnivision 5.2.5500.35 from 29 Jul 07 and I have no idea where to get a later version.

The scanner came with Photo Impression 6 software. When I go "Acquire from Scanner" it brings up the capture window but it remains blank and never shows an image of the negative that I wish to scan.

Any ideas would be gratefully received - I've wasted too much time on this already

A:Negative Scanner Not Working

Hello paust,

Welcome to 7 Forums.

Have you tried installing/running in Compatibility Mode.

Hope this helps.

Gary

Read other 3 answers
RELEVANCY SCORE 38.8

I had just accidentaly dropped a weight on my laptop and when I opened it up everything was negative. Is there something I can do to fix the problem or something I can download?
 

A:Negative Effect for Monitor

If you physically damaged the screen, it has to be repaired. You can't download software to fix it.
 

Read other 1 answers
RELEVANCY SCORE 38.8

Not sure if this will be better here or in hardware.

I'm looking for comments/suggestions on a negative scanner. Can be an all in one, or a stand alone. Just would like something "easy."
 

A:Solved: Negative Scanners

Read other 16 answers
RELEVANCY SCORE 38.8

Have asked in the past about scanning and got very good help, one additional question ,having negatives and photos of the same picture is it better to scan the photo or the neg,
Thanks for your past help.
Ralph
 

A:Scan Photo/Negative

I would recommend the negative (if you have a negative scanner), if not then use the picture.
 

Read other 7 answers
RELEVANCY SCORE 38.8

I need a formula that when value X is between, say 6 and -6, the result is True (or Pass) and when it is not within that range it is False (or Failed). If possible, I would like for this formula to be in one cell. Is this possible when there is a negative number in the formula? Here is what I have tried:

=IF(6>E14>-6, "Pass","Failed")

However, Excel does not appear to recognize the "-" in the formula as negative.

Thanks,
Twannusa
 

A:Formula with Negative Values

Without thinking about it much, just add 6 to each portion
=IF(AND(E14+6>0,12>E14+6),"Pass","Failed")
 

Read other 3 answers
RELEVANCY SCORE 38.8

I downloaded my video from my camera and tried to view it through media centre and media player but it came out in the green negative. Our windows is vista 32 bit. Tried to download updates but came up with messages of not enough space - due to wrong download - was for xp. Then did the update for vista and said it wasnt applicable for the computer. Can you help me please. The computer always did it as it is only a few months old and the graphics card is an Asus EAH4650 and we have done all the updates for it just recently.

A:avi playback in green negative

Hello kiwibabs,
So, you have the latest drivers for your video card, and all the Vista updates.
From what you are describing, i would say it's a codec/file type error.
Can you check to see what format your video camera is, what format the files you are trying to play are.
What type of camera is it, make and model.
Take a look and post your results,good luck.

Read other 5 answers
RELEVANCY SCORE 38.8

with excel 2002 is there any way of limiting a value to positive numbers?
perhaps in the dim area?
i have a value defined as range - whatever that means!
thanks
 

A:negative view of macros!

Read other 16 answers
RELEVANCY SCORE 38.8

Please is someone able to help?!

For a while now whenever i have tried to play any type of video file (dvd or downloaded file) on any player (winamp, media player, divx, to name a few) it looks like a negative. The sound is fine but the picture isn't. I can't describe it any better than to say it looks like a photographic negative!

I have been told to download some codecs which i have done but none of these have worked. I don't understand why this has happened, everything used to work fine!

A:Video Files Looks Like A Negative

to BC student_in_need,Have you updated your video drivers lately? How many colours do you have set in Display Properties? (see Control Panel>Display)To make it easier for people to help you, you need to give us some information about your system such as CPU type, RAM capacity, hard drive size, graphics card type, what version of windows and some details about your applications.

Read other 3 answers
RELEVANCY SCORE 38.8

So apparently I have -1025 mb of memory


What's the deal? I've run the same program in 1 x64 virtual machine and 1 x86 machine, without issue.

It's probably because I upgraded this machine from 7100 -> 7264.

Does anyone know why the program is seeing -1025 mb? I can finish the install, but then the program won't boot up.

A:Negative Memory during app install

It has something to do with the way Win98 (minimum requirements) applications detect memory & hd space. I have seen the same things happen with HD space

Normally, the offending apps will install with no issue.

Read other 7 answers
RELEVANCY SCORE 38.8

AVG 7.5 still works!
I am suprized but happy!

Anyone know the final cutoff date?

A:Potentially negative members name

28th February 2009 for the anti-virus, already gone for the snti-spyware.See here http://freeforum.avg.com/read.php?1,136697,backpage=,sv=

Read other 1 answers