Nested IF function

L

Lyn

Anyone can help me with nested IF function?I do not want
to do it in the visual basic editor. Just wanna a equation
in the excel sheet.

For e.g at cell C14, i need to enter serveral variables.
E.g. C14 = i enter > AI or AII or AIII respectively.
C15 > Showing App I, App II, App III respectively.


Thanks,
Lyn
 
B

Biff

Hi Lyn,

Try this:

=IF(C14="AI","APP I",IF(C14="AII","APP II",
IF(C14="AIII","APP III","")))

Biff
 
A

Arvi Laanemets

Thanks

Somehow it remained there, when I tried to overwrite it with comma (I have
semicolon for separator). So a second try:
=SUBSTITUTE(C14,"A","App ")


Arvi Laanemets
 

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

Nested IF Functions with OFFSET 3
IF function says too many nested 1
What is wrong with this nested function? 3
Nesting Functions 1
Extracting Terms and Exponents of a Text Poly Formula ?? 4
A better way than nested IF? 3
subtotal with sumif nested 1
Nested If with Lookup 1

Top