Forum Discussion
MS Excel 2013 Formula Assistance
Aloha Guys, badly needed your assistance on this scenario attached. Response is very much appreciated. Thanks. Problem: I need the answer/formula on how to arrive to the total due insurance.
Some points of clarification, if I might.
This looks more like you should be asking for the total premium due, rather than the total insurance. Is that right? Just trying to understand the context.
Could you clear up what the term "Term" refers to. You display a range from 1 to 60, but then say it should be a maximum of 12. What is it? And does it refer to months? Or something else? How does it relate to "# of Days"? Are the two redundant? If not, what purpose does #ofDays serve on this sheet?
And below 18 or above 75 in age means no coverage; right?