Formula True or False

[kbendelac]

I am looking for a formula for a range of cells less than 0 to return the value as either True of false

=COUNTA(BB6,BF6,BJ6,BN6,BR6)>0

 

[Dave Patton]

T202011b.xlsm
	B
2	TRUE
3c

Cell Formulas
Range	Formula
B2	B2	=COUNTA(BB6,BF6,BJ6,BN6,BR6)=0

N.B. Your question states less than 0
If they are all blank Counta yields 0

 

[kbendelac]

Thanks, should I be using COUNTIF less than 0 to return the string as either true or false?

 

[KGee]

Are you trying to count the number of cells in the range that are less than 0 or evaluate each as T/F?
=BB6<0 or something like =COUNTIF(BB6:BR6,"<0")

 

[kbendelac]

I am trying to compare 5 different cells that contain a number and determine of those cells if there are any zeros by returning the value with true/false

 

[kbendelac]

Sorry I just realized that I should be using the IF formula. I was able to have the formula work for one cell =IF(BB6>0, "TRUE", "FALSE"), but now I need to add the rest of the string.

BB6,BF6,BJ6,BN6,BR6

 

[Eric W]

If they're all numbers, then:

=BB6*BF6*BJ6*BN6*BR6=0

If there could be spaces or letters,

=SUM(COUNTIF(OFFSET(BB6,0,{0,4,8,12,16}),0))>0

These both return TRUE if there are any zeros.

 

[Dave Patton]

Your question is unclear.

You could show some examples of what you are have and expected results.
Review the following:

T202011b (version 1).xlsb
	A	B
1	6	TRUE
3c

Cell Formulas
Range	Formula
B1	B1	=A1>0

 

[kbendelac]

Sorry I just realized that I should be using the IF formula. I was able to have the formula work for one cell =IF(BB6>0, "TRUE", "FALSE"), but now I need to add the rest of the string.

BB6,BF6,BJ6,BN6,BR6

If they're all numbers, then:

=BB6*BF6*BJ6*BN6*BR6=0

If there could be spaces or letters,

=SUM(COUNTIF(OFFSET(BB6,0,{0,4,8,12,16}),0))>0

These both return TRUE if there are any zeros.

Yes, this worked perfect! Thank you

 

[Eric W]

Glad we could help! Thanks for the update.