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 •


#1
November 17, 2010 at 07:25:46

=IF('raw datafile'!B200<0;"0";"xxxx")

Putting quotes around it makes it TEXT try somthing like:

=IF(Sheet2!A1<0,0,Sheet2!A1)

MIKE

http://www.skeptic.com/


Report •

#2
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 •

#3
November 17, 2010 at 07:39:21

Glad I could help.

MIKE

http://www.skeptic.com/


Report •

Related Solutions


Ask Question