IF statements - 26 combinations

R

Ron Rosenfeld

Hi Ron,

The longer formula works. THe shorter one doesnt seems to work.
But for now, finally its work, so i am happy with it. And thanks for all the
effort.

Regards
Rajula
Click to expand...

I'm surprised the shorter formula doesn't work. And, if you wish, would be
happy to try to figure out why. But, so long as you have a formula that's
working, that may be all that is required.

Thanks for the feedback.
--ron
 
R

Roger Govier

Hi

If the only values that will be within A1 are ABCDE, and in B1 VWXYZ,
then
=(CODE(A1)-64)*(CODE(B1)-85)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Coding Help for Beginner 0
If, Or, and 5
Looking to added up based on a character from cell range 1
VBA for Dependents shortcut menu 0
Development combinations with exclusion of columns 0
reverse pasting rows with alternate blank cells 0
SUMIF "value if false" not working 2
What is this called in Excel or how it works? 0

Top