Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 4
Default If but with a twist:(

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
  #2   Report Post  
Posted to microsoft.public.excel.newusers
JMB JMB is offline
external usenet poster
 
Posts: 2,062
Default If but with a twist:(

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

  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1
Default If but with a twist:(

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

  #4   Report Post  
Posted to microsoft.public.excel.newusers
JMB JMB is offline
external usenet poster
 
Posts: 2,062
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
IF function - with a twist! Jamie Excel Discussion (Misc queries) 2 July 2nd 08 05:01 PM
Sum with a twist andrew Excel Discussion (Misc queries) 15 June 18th 08 08:56 AM
SaveCopyAs with a twist Rookie 1st class Excel Discussion (Misc queries) 5 January 21st 07 01:33 AM
duplicates with a twist justche Excel Discussion (Misc queries) 3 September 24th 06 07:09 AM
Vlookup With A Twist nebb Excel Worksheet Functions 2 July 16th 05 04:39 AM


All times are GMT +1. The time now is 09:19 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"