Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Writing IF Statement
Is there anyway to write an if statement for a range without identifing each
cell? Ex: If cells A1:AA1 = "test","proceed to next sheet","stop". Thanks, Angie |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Writing IF Statement
=IF(ISNUMBER(MATCH("test",A1:AA1,0))","proceed to next sheet","stop")
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Angie" wrote in message ... Is there anyway to write an if statement for a range without identifing each cell? Ex: If cells A1:AA1 = "test","proceed to next sheet","stop". Thanks, Angie |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Writing IF Statement
On Tue, 5 Jun 2007 07:56:03 -0700, Angie
wrote: Is there anyway to write an if statement for a range without identifing each cell? Ex: If cells A1:AA1 = "test","proceed to next sheet","stop". Thanks, Angie Perhaps something like: =IF(COUNTIF(A1:AA1,"test")0,"proceed to next sheet","stop") --ron |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Writing IF Statement
if you want all of them to say test
=if(or(A1:AA1<"test"),"proceed to next sheet","stop") entered as an array control-shift-Enter if you want any of them ot say test then =if(or(A1:AA1="test"),"proceed to next sheet","stop") entered as array "Angie" wrote: Is there anyway to write an if statement for a range without identifing each cell? Ex: If cells A1:AA1 = "test","proceed to next sheet","stop". Thanks, Angie |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Writing IF Statement
Thanks so much, but I'm having trouble with one piece.
Using the same example, A1 has the following formula: =If a2=sheet1!a2,"test","redo" C1 has the array =if(or(A1:AA1="test"),"proceed to next sheet","stop") The problem is the array appears to only work if Row A changes on the active sheet not sheet1. If sheet1!a2 changes and a2 = redo (active sheet) then c1 doesn't change to "stop". c1 only changes to "stop" if row a on the active sheet changes. I hope this makes sense. Thanks again. "bj" wrote: if you want all of them to say test =if(or(A1:AA1<"test"),"proceed to next sheet","stop") entered as an array control-shift-Enter if you want any of them ot say test then =if(or(A1:AA1="test"),"proceed to next sheet","stop") entered as array "Angie" wrote: Is there anyway to write an if statement for a range without identifing each cell? Ex: If cells A1:AA1 = "test","proceed to next sheet","stop". Thanks, Angie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Statement writing problem | Excel Worksheet Functions | |||
writing a statement | Excel Worksheet Functions | |||
Help writing an IF statement | Excel Worksheet Functions | |||
when writing an IF statement what is the syntax for "Not Equal to. | Excel Discussion (Misc queries) | |||
when writing an IF statement what is the syntax for "Not Equal to. | Excel Discussion (Misc queries) |