Long Iff Statement

[Guest]

Can I do an iff statment like:

=Iff([Text93]<[Text84] Or [CDV]<[ Text68] Or [CHSI]<[Text70] Or
[Text39]<[Text82] Or [DIGI]<[Text71] Or [Text40]<[Text83] Or
[Text60]<[Text102],Yes,No)

Where if any of these statements are true it will give a result of Yes, if
not then No?

 

[BruceM]

I think that would work. What happened when you tried it?

 

[Guest]

I get: #Name?
I thougth the text might have something to do with it, so I tried it with
actual numbers, true=.05, false=1 with the same result. I just tried:
=Iff([Text93]<[Text84],0.05,Iff([CDV]<[Text68],0.05,Iff([CHSI]<[Text70],0.05,Iff([Text39]<[Text82],0.05,Iff([DIGI]<[Text71],0.05,Iff([Text40]<[Text83],0.05,Iff([Text60]<[Text102],0.05,1)))))))
but still get: #Name?

--
Mark Matzke

I think that would work. What happened when you tried it?

Can I do an iff statment like:

=Iff([Text93]<[Text84] Or [CDV]<[ Text68] Or [CHSI]<[Text70] Or
[Text39]<[Text82] Or [DIGI]<[Text71] Or [Text40]<[Text83] Or
[Text60]<[Text102],Yes,No)

Where if any of these statements are true it will give a result of Yes, if
not then No?

 

[Douglas J. Steele]

It's IIf, not Iff.



--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

I get: #Name?
I thougth the text might have something to do with it, so I tried it with
actual numbers, true=.05, false=1 with the same result. I just tried:
=Iff([Text93]<[Text84],0.05,Iff([CDV]<[Text68],0.05,Iff([CHSI]<[Text70],0.05,Iff([Text39]<[Text82],0.05,Iff([DIGI]<[Text71],0.05,Iff([Text40]<[Text83],0.05,Iff([Text60]<[Text102],0.05,1)))))))
but still get: #Name?

--
Mark Matzke

I think that would work. What happened when you tried it?

in
message news:[email protected]...

Can I do an iff statment like:

=Iff([Text93]<[Text84] Or [CDV]<[ Text68] Or [CHSI]<[Text70] Or
[Text39]<[Text82] Or [DIGI]<[Text71] Or [Text40]<[Text83] Or
[Text60]<[Text102],Yes,No)

Where if any of these statements are true it will give a result of Yes,
if
not then No?

 

[Guest]

Yup, duh! That was it, thanks for everything!
--
Mark Matzke

It's IIf, not Iff.



--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

I get: #Name?
I thougth the text might have something to do with it, so I tried it with
actual numbers, true=.05, false=1 with the same result. I just tried:
=Iff([Text93]<[Text84],0.05,Iff([CDV]<[Text68],0.05,Iff([CHSI]<[Text70],0.05,Iff([Text39]<[Text82],0.05,Iff([DIGI]<[Text71],0.05,Iff([Text40]<[Text83],0.05,Iff([Text60]<[Text102],0.05,1)))))))
but still get: #Name?

--
Mark Matzke

I think that would work. What happened when you tried it?

in
message Can I do an iff statment like:

=Iff([Text93]<[Text84] Or [CDV]<[ Text68] Or [CHSI]<[Text70] Or
[Text39]<[Text82] Or [DIGI]<[Text71] Or [Text40]<[Text83] Or
[Text60]<[Text102],Yes,No)

Where if any of these statements are true it will give a result of Yes,
if
not then No?

 

[BruceM]

I looked right past that part.

It's IIf, not Iff.



--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

I get: #Name?
I thougth the text might have something to do with it, so I tried it with
actual numbers, true=.05, false=1 with the same result. I just tried:
=Iff([Text93]<[Text84],0.05,Iff([CDV]<[Text68],0.05,Iff([CHSI]<[Text70],0.05,Iff([Text39]<[Text82],0.05,Iff([DIGI]<[Text71],0.05,Iff([Text40]<[Text83],0.05,Iff([Text60]<[Text102],0.05,1)))))))
but still get: #Name?

--
Mark Matzke

I think that would work. What happened when you tried it?

"(e-mail address removed)" <[email protected]>
wrote in
message Can I do an iff statment like:

=Iff([Text93]<[Text84] Or [CDV]<[ Text68] Or [CHSI]<[Text70] Or
[Text39]<[Text82] Or [DIGI]<[Text71] Or [Text40]<[Text83] Or
[Text60]<[Text102],Yes,No)

Where if any of these statements are true it will give a result of
Yes, if
not then No?