Thread: median if
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
chg chg is offline
external usenet poster
 
Posts: 15
Default median if

Try this:

IF(Month(*where you wanna look*)=5, etc)

Did you by any chance want to do the formula like this: =if(and
(condition 1, conditon 2),do this if true,do this if false)