VLOOKUP and IF Formula Question

[thekgbjr]

=IF(F6="Companion",(E6*1440)*(G6/60),G6),IF(F6="CNA",(E6*1440)*(G6/60),G6),IF(F6="Home Health Aide",(E6*1440)*(G6/60),G6)

That is the formula, I am creating an invoice with drop down boxes using data validation. The invoice contains many different services most of which are just a flat fee. The services provided by the CNA, Companion and home health aide are hourly.
When I click the drop down box and select, fir instance, "Companion" I need it to calculate the hourly rate to the minute and multiply it by the number of minutes worked. If I select anything other than the CNA, Companion or Home Health Aide, I just want it to show the flat fee with no calculation.

In the formula above, the first section worked fine, when I added the additional IF statements it gives me the #VALUE Error and no longer works.

Any ideas?

 

[Expiry]

you only need the G6 bit once, ie. if all of your conditions are false.

=IF(F6="Companion",(E6*1440)*(G6/60),IF(F6="CNA",(E6*1440)*(G6/60),IF(F6="Home Health Aide",(E6*1440)*(G6/60),G6)))

 

[MrKowz]

You're using too many arguments:

=IF(F6="Companion",(E6*1440)*(G6/60),IF(F6="CNA",(E6*1440)*(G6/60),IF(F6="Home Health Aide",(E6*1440)*(G6/60),G6)))

 

[joe.muckle]

Try the following:

=IF(F15="Companion",(E6*1440)*(G6/60),IF(F6="CNA",(E6*1440)*(G6/60),IF(F6="Home Health Aide",(E6*1440)*(G6/60),G6)))

 

[thekgbjr]

Bless you all