True/False Statements

  • Thread starter Thread starter newgram
  • Start date Start date
N

newgram

I'm not sure if I'm asking this question correctly but here goes..

I want to create a true/false statement for a names list in my exce
spreadsheet that gets pasted into an Access db that creates
validation for reporting purposes.

Thanx in advance for the assistance
 
Hi
not really sure what you're trying to achieve. Could you give an
example?
 
Hi newgram!

Basic form for returning TRUE and FALSE is:

=IF(Criteria,TRUE,FALSE)

You can omit the third argument and also use the form (eg) =A1>A2 to
return TRUE or FALSE.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

TRUE/FALSE STATEMENT 4
If statement for a range of cells 3
My exact "text" statement is returning a value of 0 for false?? 1
Value if an if statement is false 3
If a value is found return a true/false 4
If Statement returns true when false? 3
Excel data validation 1
Need "true" or "false" 4

Back
Top