Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto populate with value
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto populate dates | Excel Discussion (Misc queries) | |||
How to insert auto populate calendar icon? | Excel Discussion (Misc queries) | |||
Auto Populate Time | Excel Discussion (Misc queries) | |||
Function for Auto Populate | Excel Worksheet Functions | |||
Auto populate cells based on 2 cells division. | Excel Discussion (Misc queries) |