| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I get cell data in multiple Excel files into one summary fi | Excel Worksheet Functions | |||
| Sum up a particlar cell in multiple Excel worksheets within same b | Excel Worksheet Functions | |||
| How do I split a cell into multiple rows/columns? | Excel Discussion (Misc queries) | |||
| How do I remove multiple hyperlinks in the same cell (Excel)? | Charts and Charting in Excel | |||
| Pasting Word table cell with paragraph markers into single Excel c | Excel Discussion (Misc queries) | |||
Hybrid Mode
