If but with a twist:(
Yep, I overlooked the =. Thanks for the correction
=if(countif(a6:F6,:"ok")=3,"ok","Problem")
"Steven Terry" wrote:
i think it would be =if(countif(a6:F6,:"ok")=,"ok","Problem")
This would make it greater or equal to three ok's.
"JMB" wrote:
try:
=If(CountIf(A1:F1, "OK")=3, "OK", "Problem")
"AVB Over My Head" wrote:
I have 6 columns each cell has a value either €śOk€ť or €śProblem€ť. I
would like to figure out how to automate on column 7 if I have three
€śOk€ť in my row then type €śOK€ť if I have less than 3 OK in my row then
type €śProblem€ť
A1 B1 C1 D1 E1
F1 G1
1 Ok Ok Problem Problem Problem Problem Problem
2 Ok Problem Ok Ok Problem Ok
Ok
|