View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ken Wright
 
Posts: n/a
Default How do I do multiple IF statemnets in one cell in Excel?

=IF(A1=2,"Yes",IF(A1=3"No","Maybe"))

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------


"Stephen Olert" <Stephen wrote in message
...
I am trying to make 2 different if statements for one cell in a spreadsheet
and I can't figure out how to do it.