Posted to microsoft.public.excel.worksheet.functions
|
|
Help with IF statement
Can I include an arrey that referances another sheet?
"Max" wrote:
"Sean.rogers" wrote:
Can you have multiple tests, in the test section of the if statement? For
example.
If (A2=1or2or5or25,True,False)
Try it like this: =IF(OR(A1={1,2,5,25}),"Y","N")
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
|