function for true/false on a range of cells

E

ewil

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?
 
J

Jerry W. Lewis

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...
 
E

ewil

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