LinkBack URL
About LinkBacks
I need to have a cell be able to except an A, B, or C if another cell is equal to 1. I also need that same cell to accept a 1 to 99999 if the same other cell is equal to 2. Any Ideas? I am using the latest version of excel.
I need to have a cell be able to except an A, B, or C if another cell is equal to 1. I also need that same cell to accept a 1 to 99999 if the same other cell is equal to 2. Any Ideas? I am using the latest version of excel.
Last edited by bsnarles; 07-30-2010 at 03:52 PM.
try
=IF(B1=1,OR(A1="a",A1="b",A1="c"),IF(B1=2,AND(A1>=1,A1<=99999)))
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
It works. Thanks a bunch for your help. Would never have figured it out on my own.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks