View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default Multiple IF formulas

Yes, there are several ways to do that. What are you really trying to do?


One way:

=IF(<condition1,1, 2) + IF(<condition2, 3, 4)


another:

=IF(<condition1, 1, IF(<condition2, 2, 3))


In article ,
sriddle wrote:

Can I put more than on IF formula in a cell?