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.
=IF(A1=2,quot;Yesquot;,IF(A1=3quot;Noquot;,quot;Maybequot;))
--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03
------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------quot;Stephen Olertquot; lt;Stephen gt; wrote in message
...
gt;I am trying to make 2 different if statements for one cell in a spreadsheet
gt; and I can't figure out how to do it.
- May 16 Wed 2007 20:37
How do I do multiple IF statemnets in one cell in Excel?
close
全站熱搜
留言列表
發表留言