#### sue.Caradonna

##### New Member

- Joined
- Jan 17, 2005

- Messages
- 8

{=MEDIAN(IF((Team=$S$3)*(JobClassification=$T$3),AgeToday,IF(ISNA(ERROR.TYPE(AgeToday)),0,IF(ERROR.TYPE(AgeToday)=6,1,0)))))))}

Can you help me amend the formula to show the correct result if the formula returns a value and also a "0" if the formula results in 0 is no result is available.

Hope this makes sense.

Many thanks for your help. Its greatly appreciated