I am trying to run a Case function within a Case function and I can't get it to work. The function deductible(DDD) runs ok by itself. When I try to run it from dedkind(dedtype) it won't run. I was told that it doesn't have a number to relate to but I don't understand. In dedkind(dedtype) the Case is in T18.
function deductible(DDD) as double
Select case DDD
Case is > 25
deductible = Range("T17")
Case is >=5
deductible = Range ("T17") -5
Case is <5
deductible = 0
End select
End function
Function dedkind(dedtype) as double
Select case dedtype
Case is = "DDD"
dedkind = deductible(DDD)
Case is = "DDD10"
Dedkind = 10
Case is = "DDDIP"
dedkind = 15
End select
End function
Bookmarks