Formula wth multiple scenarios

[smcduffi]

See attached worksheet.

I need to add a scenario to the existing formula in cell P14 to include the following logic:

If L5 = "Non-Par", then sum(I14-O14).

Any assistance is greatly appreciated!

[Cutter]

Depending on what the priority is:

=IF(A14="","",IF(J14>0,J14*G14,IF(L5="Non-Par",I14-O14,L14-O14)))

=IF(A14="","",IF(L5="Non-Par",I14-O14,IF(J14>0,J14*G14,L14-O14)))

[Marcol]

Not to sure about this, but try this in P14, as Cutter says it depends on the priorities.

Please Login or Register  to view this content.

Hope this helps.

[DonkeyOte]

@Marcol, being the pedant I am both SUM calls are superfluous in the above.

[smcduffi]

Thank you - but this doesn't give me what I'm looking for (plus I forgot to add the *.80). What about this instead....

See cell L14 - add the scenario:

But If L5="Non-Par" then sum(I14*.80)*G14.

Basically - I want the cell to be blank if A14 is blank
If L5 is anything other than Non-Par, I want K14*G14,
but if L5= Non Par, I want the scenario above to apply.

Thanks for all of your assistance.

[DonkeyOte]

Based purely on the logic detailed in the above narrative:

Please Login or Register  to view this content.

[smcduffi]

Absolutely perfect! Problem solved!