Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
If, ElseIf
I have a workbook for tracking the whereabouts of equipment. Equipment is
allocated, by an "X" in columns and a cell, at the top of the column (using data validation) records if the equipment is "Allocated" or "In Use" or "Returned" and changes the colour of the column accordingly. There are several columns of "Allocated" and "In Use" equipment at any one time. How can I, in a separate column, mark each individual item of equipment as "Available" or Not Available" depending on the three conditions of "Allocated" & "In Use" and the "X" |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
If, ElseIf
I don't think this is too difficult, but it would help if you show the
sample data and which cells they are in to avoid guessing. -- HTH RP (remove nothere from the email address if mailing direct) "mast" wrote in message ... I have a workbook for tracking the whereabouts of equipment. Equipment is allocated, by an "X" in columns and a cell, at the top of the column (using data validation) records if the equipment is "Allocated" or "In Use" or "Returned" and changes the colour of the column accordingly. There are several columns of "Allocated" and "In Use" equipment at any one time. How can I, in a separate column, mark each individual item of equipment as "Available" or Not Available" depending on the three conditions of "Allocated" & "In Use" and the "X" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Elseif? | Excel Worksheet Functions | |||
if elseif | Excel Discussion (Misc queries) | |||
elseif formula | Excel Discussion (Misc queries) | |||
ElseIf | Excel Programming | |||
If...Elseif...End If | Excel Programming |