If condition problem Hi.... How to use the multiple cells in if condition. =if(A2="Car","Yes","No") (This working) =if(A2:A15="Car","Yes","No") (Please Answer) If ALL cells have to equal car to get a
...statement how do you build more than one "If" arguement in a single cell Hi, MS Excel's logical test (IF) by its very nature has already two (2) "IF" conditions in a cell, "if true" and "if false". ...
ms excel function i need to know a function that i can for excel. i will use it for scoring. say for example: a = 3 b = 2 c = 1 d = 0 is there a function that I can use to do this? I will be using at ...
Question about Office 2003 Basic Edition English (s55-00066) for PC
what function can make a text/string BOLD? sample data: A1: How to use A2: Microsoft Excel. I want A3 to be a formula combining A1 & A2 but with A2 in BOLD letters. example: A3: =A1 & bold(A2) The ...
Question about Office Standard for PC
code for find the Ms access database size using visual basic hi... i want to find the database size using vb.. for example i have payroll database in that 2 r 3 tables are there.. now i need to find ...
...Statement. Great alternative to Else If Statements CONVERSION VBA: CBool(),CByt(),CCur(),CDate(),CDbl()Double,CDec(),CInt(),CLng(),CSng(),CStr(),CVar(). Example dDate=cDate("25-Jan-07") Convert ...
...statement, you can move to the bookmarked record directly in code. Here's a good VB example that compares the bookmakr property to the movefirst and movelast properties. This should answer your ...
...JDBC code to enable remote database access. You will learn how to create a table, insert values into it, query the table, retrieve results, and update the table with the help of a JDBC ...
LENGHTY IF STATEMENT I am working on an if and statement that is not understanding a cell with both text and numbers. I am trying to meet certain conditions with and statement also there is alot of ...
what are the heirarchy of operation? Hi, The following information on "Hierarchy of Operations" was taken from Pages 45-46 of the "Microsoft QuickBasic 4.0: Basic Language Reference" manual for ...
Usually answered in minutes!
7,276 Questions
4,613 Questions
4,482 Questions
4,191 Questions
3,681 Questions