Long Iff Statement

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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


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

[email protected] said:
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?
Click to expand...
Click to expand...
 
It's IIf, not Iff.



--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


[email protected] said:
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


BruceM said:
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?
Click to expand...
Click to expand...
Click to expand...
 
Yup, duh! That was it, thanks for everything!
--
Mark Matzke


Douglas J. Steele said:
It's IIf, not Iff.



--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


[email protected] said:
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


BruceM said:
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?
Click to expand...
Click to expand...
Click to expand...
 
I looked right past that part.

Douglas J. Steele said:
It's IIf, not Iff.



--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


[email protected] said:
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


BruceM said:
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?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top