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

Scrabble Value calculation for Welsh words 0
if then formula 1
VLOOKUP & IF or Sumproduct 7
How to set the formula? 4
copy and paste the cell with formula ="1" 3
Need Major Help on the Macro 12
Need formula 3
help with formula 1

Top