ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I do multiple IF statemnets in one cell in Excel? (https://www.excelbanter.com/excel-worksheet-functions/79928-how-do-i-do-multiple-if-statemnets-one-cell-excel.html)

Stephen Olert

How do I do multiple IF statemnets in one cell in Excel?
 
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.

Ken Wright

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.





All times are GMT +1. The time now is 12:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com