LinkBack URL
About LinkBacks
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!
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!
Last edited by smcduffi; 12-30-2010 at 03:41 PM.
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)))
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.
Last edited by Marcol; 12-30-2010 at 02:31 PM.
If you need any more information, please feel free to ask.
However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....
Also
اس کی مدد کرتا ہے اگر
شکریہ کہنے کے لئے سٹار کلک کریں
If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.
@Marcol, being the pedant I am both SUM calls are superfluous in the above.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
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.
Based purely on the logic detailed in the above narrative:
Please Login or Register to view this content.
Absolutely perfect! Problem solved!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks