Nested IF function

  • Thread starter Thread starter Lyn
  • Start date Start date
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
 
Hi Lyn,

Try this:

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

Biff
 
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
 
Back
Top