Questions & Answers for: Microsoft Office value statement

...series of conditions for a single logical test of a cell, you can replace the IF TRUE and IF FALSE values with other IF Condition(s) (of course the syntax must be correct with appropriate

...Looks like your GROUP BY subclause says to group by Force_no but also the yyyy and m datepart values for Subs_Dt as separate items. [Also since you are returning "Force_no AS FN", you need to ...

...value you want to appear when you select that cell as a solution to a "What If" statement. I build training spread sheets that let people generate pre-programmed answers to various data entries. ...

...statement with an output to a file as in DIR payroll.mdb>dbsize.txt and then read from the text file, the first field of the second line being the name (which you really don't need) then the size ...

...statement is true. The trick y part is also on one instatnce a1 should begin with N and the second character should not be a number 1 through 9. When I do this is does not recongize the second ...

...statement returns the true value first and then the false value ie =If(condition,True,False) So if the condition is met then it is true so it will return the true part and if its false it will ignore ...