IF AND help

  • Thread starter Thread starter P.Rumpz
  • Start date Start date
P

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
 
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
 
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
 
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
 
Thank you RagDyer! It worked like a charm.


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


P
 
Back
Top