Solved How to get excel to enter true in a cell if others are true

December 23, 2014 at 07:47:34
Specs: Windows 7
I want excel to enter true into cell O2 if cell N2 through N20 are true. I have tried multiple methods but nothing has seemed to work. Does anyone know what formula I need to use for this, or even if it can be done?

See More: How to get excel to enter true in a cell if others are true

Report •


#1
December 23, 2014 at 09:30:14
✔ Best Answer
You could do something like:

=IF(COUNTIF(N2:N20,"TRUE")=19,"TRUE","")

MIKE

http://www.skeptic.com/


Report •

#2
December 23, 2014 at 10:18:48
After slowly working my way through it I figured out that I could replace true for 1 and false for 0. Then in cell O2 I set it up so that if numbers in cell N2:N20 added to 19 the statement was true.

Report •

#3
December 23, 2014 at 20:41:36
Just FYI...

You don't need the quotes around the logical operators, TRUE or FALSE, when you use them in a formula.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question