going beyond just true and false values

B

Brian

Essentially I want to write a function that says this
within cell b1: if cell a1 starts with the number 1 then goto c1, or if
a1 starts with the number 2 then goto d1, or if a1 starts with the number 3
then goto e1, and so on up to the number 5 with the last being: or if a1
starts with text then Z1.

can this be done?
Brian
 
F

Frank Kabel

Hi
try the following formula
=IF(ISNUMBER(--LEFT(A1,1)),OFFSET($B$1,0,--LEFT(A1,1)),IF(A1<>"",Z1,"no
t defined"))
 

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

SUMIF "value if false" not working 2
COUNTING THE SAME VALUES IN A SHEET 3
Conditional Formatting Formula 3
Page numbering with Merged Document and IF statements 1
Baffeling IF statement 7
problem with time subtraction 7
Combining two formulas 0
Rolling totals 1

Top