true value

  1. C

    INDEX MATCH multiple criteria with true value for blank cell condition

    Hi there, please someone help me to solve this problem. I am really confused. I have a reference table like this. <tbody> Category condition 1 condition 2 condition 3 condition 4 A -150 to 140 0 to 15 B 0 to 50 C -150 to 140 0 to 1000 0 to 50000 4.5 to 14 D -150 to...
  2. S

    Need to to see true value result of a Concatenated cell

    I have 4 cells (A1-A4) that concatenate into a fifth cell (A5). How can I have the result in A5 show in the formula window of A6 as the actual result instead of the concatenate formula as it does in A5?
  3. A

    Using Case statement with True and False keywords

    I have an Excel 'database' that I need to update some records on but ubfortunately the Select Case statement is not working as I expected it to. This the code that I have: Select Case cbVI2 Case = True And cbHI2 = True Range("U" & Count).Value = "DUAL" Case = True And cbHI2 = False Range("U"...
  4. J

    Automating Importing IQY Files

    I am writing VBA macro in Excel 2003 that includes opening an IQY file. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> When I open an IQY file manually, I get a Import Data dialog box that asks<o:p></o:p> <o:p></o:p> "Where do you want to put...

Some videos you may like

This Week's Hot Topics