Thread: Function within a function?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
  
Posts: 5,939
Default Function within a function?
You can do this...(I left the quotes around 122 as I assume B5 is Text???)

=IF(AND(B5="122",SUM(D5:L5)1),1,0)
or
=AND(B5="122",SUM(D5:L5)1)
--
HTH...

Jim Thomlinson


"Stefan" wrote:

Why does this not work: =IF(AND(B5="122"),(SUM(D5:L5)1)),1,0
Reply With QuoteReply With Quote