sue.Caradonna
New Member
- Joined
- Jan 17, 2005
- Messages
- 8
I have a spreadsheet with the following formula which returns information from a database. However, if the "S3" and "T3" gives in a "0" result from the database, the function returns #NUM!. I tried to get rid of the "#NUM! by adding the following If(ISNA(Error.TYPE etc code but it now returns "0" result even if the result calculates data.
{=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
{=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