function for true/false on a range of cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a range of cells with text that I want to get a true/false calculation. IF function only takes 1 cell at a time, or I am at a loss to how to put in an addtional function to see the range then calculate. Any ideas?
 
If you input a range into the IF function, it will return an array (fill
a range) if you array enter it (Ctrl-Shift-Enter).

Jerry
I have a range of cells with text that I want to get a true/false
Click to expand...
calculation. IF function only takes 1 cell at a time, or I am at a
Click to expand...
 
Jerry, thank you so much... definition of array in Excel Help did not explain it true capabilities...
 
You're welcome. Glad it helped.

Jerry
Jerry, thank you so much... definition of array in Excel Help did not explain it true capabilities...

:
Click to expand...
 
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

If statement for a range of cells 3
function for true/false calculation on a range of cells 1
VBA set thick borders around non empty cells in range 0
Center All Pictures in Excel Cells 1
Excel VBA - counting cells by colors and names to it in two different rows. 0
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Excel VBA setting Ranges 2
Trying to run excel vba code when cell value changes from empty to entered value. 1

Back
Top