Something better than OR()
You're welcome. Thanks for the feedback!
--
Biff
Microsoft Excel MVP
"Lee" wrote in message
...
Thanks, it works! I don't understand the isnumber part but will read more
in the help file.
Thanks again.
Lee
"T. Valko" wrote in message
...
Try this:
=IF(B2="misc",E2,IF(ISNUMBER(MATCH(B2*1,I$2:I$23,0 )),E2,E2*20/18))
--
Biff
Microsoft Excel MVP
"Lee" wrote in message
...
=IF(B2="misc",E2,IF(OR(B2*1=I$2,B2*1=I$3,B2*1=I$4, B2*1=I$5,B2*1=I$6,B2*1=I$7,B2*1=I$8,B2*1=I$9,B2*1= I$10,B2*1=I$11,B2*1=I$12,B2*1=I$13,B2*1=I$14,B2*1= I$15,B2*1=I$16,B2*1=I$17,B2*1=I$18,B2*1=I$19,B2*1= I$18,B2*1=I$19,B2*1=I$20,B2*1=I$21,B2*1=I$22,B2*1= I$23),E2,E2*20/18))
Is there a better way to do the above formula? I have experimented with
an array but can't get it to work.
Thanks for any help or suggestions.
Lee
|