IF AND help

[P.Rumpz]

Here is my current function argument:

=IF(D5="Premium"
"71.34",IF(D5="Standard","71.34",IF(D5="OnePlan","72.39",IF(D5="Premiu
Health","71.34",IF(D5="HealthPlus","n/a", IF(D5="","0"))))))))

--I am assigning a Fee Value based on what type of Health Care eac
person has--

How can I properly have a 'zero' calculated for Fee Value where D* i
empty or contains characters other than what I am looking for?

Also, for "OnePlan", there are two different fees - one for thos
living in Michigan and one for those outside of Michigan. How do
calculate the Fee Value properly? I have column F with values "1" fo
those living in Michigan and "0" for those outside Michigan.

Any help would br greatly appreciated.


Thanks,
Pa

 

[RagDyer]

Try This:

=IF(OR(D5={"Premium","Standard","PremiumHealth"}),71.34,IF(D5="HealthPlus","
n/a",0))

Note: - There are *no* spaces between the double words.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



Here is my current function argument:

=IF(D5="Premium",
"71.34",IF(D5="Standard","71.34",IF(D5="OnePlan","72.39",IF(D5="Premium
Health","71.34",IF(D5="HealthPlus","n/a", IF(D5="","0"))))))))

--I am assigning a Fee Value based on what type of Health Care each
person has--

How can I properly have a 'zero' calculated for Fee Value where D* is
empty or contains characters other than what I am looking for?

Also, for "OnePlan", there are two different fees - one for those
living in Michigan and one for those outside of Michigan. How do I
calculate the Fee Value properly? I have column F with values "1" for
those living in Michigan and "0" for those outside Michigan.

Any help would br greatly appreciated.


Thanks,
Pat

 

[RagDyer]

Forgot one of the arguments!

Try this:

=IF(OR(D5={"Premium","Standard","PremiumHealth"}),71.34,IF(D5="HealthPlus","
n/a",IF(D5="OnePlan",72.39,0)))
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Try This:

=IF(OR(D5={"Premium","Standard","PremiumHealth"}),71.34,IF(D5="HealthPlus","
n/a",0))

Note: - There are *no* spaces between the double words.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



Here is my current function argument:

=IF(D5="Premium",
"71.34",IF(D5="Standard","71.34",IF(D5="OnePlan","72.39",IF(D5="Premium
Health","71.34",IF(D5="HealthPlus","n/a", IF(D5="","0"))))))))

--I am assigning a Fee Value based on what type of Health Care each
person has--

How can I properly have a 'zero' calculated for Fee Value where D* is
empty or contains characters other than what I am looking for?

Also, for "OnePlan", there are two different fees - one for those
living in Michigan and one for those outside of Michigan. How do I
calculate the Fee Value properly? I have column F with values "1" for
those living in Michigan and "0" for those outside Michigan.

Any help would br greatly appreciated.


Thanks,
Pat

 

[RagDyer]

Finally decided to read the entire question.

For the third time, try this:
=IF(OR(D5={"Premium","Standard","PremiumHealth"}),71.34,IF(D5="HealthPlus","
n/a",IF(AND(D5="OnePlan",F5=1),72.39,IF(AND(D5="OnePlan",F5=0),99.5,0))))

You can change the pricing for the differing conditions in F5.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


Forgot one of the arguments!

Try this:

=IF(OR(D5={"Premium","Standard","PremiumHealth"}),71.34,IF(D5="HealthPlus","
n/a",IF(D5="OnePlan",72.39,0)))
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Try This:

=IF(OR(D5={"Premium","Standard","PremiumHealth"}),71.34,IF(D5="HealthPlus","
n/a",0))

Note: - There are *no* spaces between the double words.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



Here is my current function argument:

=IF(D5="Premium",
"71.34",IF(D5="Standard","71.34",IF(D5="OnePlan","72.39",IF(D5="Premium
Health","71.34",IF(D5="HealthPlus","n/a", IF(D5="","0"))))))))

--I am assigning a Fee Value based on what type of Health Care each
person has--

How can I properly have a 'zero' calculated for Fee Value where D* is
empty or contains characters other than what I am looking for?

Also, for "OnePlan", there are two different fees - one for those
living in Michigan and one for those outside of Michigan. How do I
calculate the Fee Value properly? I have column F with values "1" for
those living in Michigan and "0" for those outside Michigan.

Any help would br greatly appreciated.


Thanks,
Pat

 

[P.Rumpz]

Thank you RagDyer! It worked like a charm.


Kudos to a helpful forum and the folks who make it happen.


P