Link to home
Start Free TrialLog in
Avatar of akbiro
akbiroFlag for United States of America

asked on

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
Avatar of jimyX
jimyX

no attachment
Try using the   IIF() function.

=IF( logical test, value if true, value if false)
ASKER CERTIFIED SOLUTION
Avatar of barry houdini
barry houdini
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of akbiro

ASKER

Perfect  THANKS