View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default Multiple IF formulas

Yes, here's one example with 3 IFs:

=IF(A1="","blank",IF(A1<0,"negative",IF(A10,"posi tive","zero")))

Hope this helps.

Pete

On Dec 9, 11:35*pm, sriddle wrote:
Can I put more than on IF formula in a cell?