I am currently setting up an asset control sheet and in D2 i have
multiple bundle type eg server, till, master till this then shows the
hardware included in each bundle eg pc, printer, chip & pin touch
screen etc

I am trying to auto populate the hardware columns so if it is a till it
enters a value of "1" in the relevant fields so i can then count each
piece of hardware

I need a statement that will look at D2 and return a value of "1" if
the value = till or master till but not server

I have tried an if statement but it only gives 1 logical argument and
can not find any other way to get a value returned


--
chris.howes
------------------------------------------------------------------------
chris.howes's Profile: http://www.excelforum.com/member.php...fo&userid=5660
View this thread: http://www.excelforum.com/showthread...hreadid=550283