Additional argument

[CVN55]

Hi
I have this formula:
=IF(SUMMARY!$E$32="INV",SUMPRODUCT($J$9:$J$15,M9:M15)/60*1.3,SUMPRODUCT($J$9:$J$15,M9:M15)/60)
I know want to add in an extra formula to say that if $E$32 ="EU ",SUMPRODUCT($J$9:$J$15,M9:M15)/60*1.25

So basically 3 arguments/criteria:
If a certain cell says "INV" I want the sumproduct of 2 rows multiplied by 30% (in minutes, hence the /60)
If a certain cell says "EU " I want the sumproduct of 2 rows multiplied by 25%
If neither of these, then I want the sumproduct of 2 rows multiplied

Can anyone help me add this third argument please to the formula?

Cheers
Catherine

 

[markmzz]

Re: Addiional argument

Hi
I have this formula:
=IF(SUMMARY!$E$32="INV",SUMPRODUCT($J$9:$J$15,M9:M15)/60*1.3,SUMPRODUCT($J$9:$J$15,M9:M15)/60)
I know want to add in an extra formula to say that if $E$32 ="EU ",SUMPRODUCT($J$9:$J$15,M9:M15)/60*1.25

So basically 3 arguments/criteria:
If a certain cell says "INV" I want the sumproduct of 2 rows multiplied by 30% (in minutes, hence the /60)
If a certain cell says "EU " I want the sumproduct of 2 rows multiplied by 25%
If neither of these, then I want the sumproduct of 2 rows multiplied

Can anyone help me add this third argument please to the formula?

Cheers
Catherine

Hi!

Maybe the formula below can helps.

=SUMPRODUCT($J$9:$J$15,M9:M15)/60*IFERROR(VLOOKUP(SUMMARY!$E$32,{"INV",1.3;"EU ",1.25},2,0),1)_{^{<strike>
</strike>}}
Markmzz