How to put data from a cell into an if state?

November 17, 2010 at 07:18:04
Specs: Windows XP
Hello Peeps,

been using this site a lot and i have come quite far now, but this thing i cant figure out:

I am making a datafile in excel 2003? which should change cells into red when exceeding certain limits:
=IF('raw datafile'!B200<0;"0";"xxxx")

but in the xxxx part i tried to refer to data from 'raw datafile'!b200, what i cant get fixed.

In other words:

I have an if statement in which a certain number should be displayed into a cell, unless its below zero, or negative, because then there should be only "0". if i place the 'raw datafile'!b200 between instead of the xxxx it just sais all that -.-

I tried some stuff but it doesnt work and i am getting a bit frustrated since google aint working like i want it either :P

I hope you can help me !

Gr D.

See More: How to put data from a cell into an if state?

Report •

November 17, 2010 at 07:25:46
=IF('raw datafile'!B200<0;"0";"xxxx")

Putting quotes around it makes it TEXT try somthing like:



Report •

November 17, 2010 at 07:31:43
Ow maj gawd ^^

you are totally right, i removed the quotes around 'raw datafile'!b200 and it totally took the origininal number !

thnx so much !

Report •

November 17, 2010 at 07:39:21
Glad I could help.


Report •

Related Solutions

Ask Question