Thread: Nested if
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
 
Posts: 3,718
Default Nested if

=CODE(LOWER(A1))-96


"ab3d4u" wrote:


I have 4 "if" scenarios for which I am looking a formula. It is just a
basic scenario where I have 4 choices and I need this formula to read
the four options correctly. Kind of if a then 1, if b then 2,,,
Thanks for your help.
Merry Christmas and Happy Holidays for all.




--
ab3d4u