• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 275
  • Last Modified:

Excel formula

Attached is my excel worksheet.  Can you take a look at cell F59.  That formula is supposed to apply a 5% discount AFTER for the entire total only after the order exceeds 25 cases.  Anything less than 25 cases get no discount.

Can you please tell me what I screwed up.

THANKS
0
akbiro
Asked:
akbiro
1 Solution
 
jimyXCommented:
no attachment
0
 
Ron MalmsteadInformation Services ManagerCommented:
Try using the   IIF() function.

=IF( logical test, value if true, value if false)
0
 
barry houdiniCommented:
Try

=IF(Quantity>25,0.95,1)*Total

replace Quantity and Total with the relevant cells or calculations

regards, barry
0
 
akbiroAuthor Commented:
Perfect  THANKS
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

Tackle projects and never again get stuck behind a technical roadblock.
Join Now