akbiro
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
Can you please tell me what I screwed up.
THANKS
no attachment
Try using the IIF() function.
=IF( logical test, value if true, value if false)
=IF( logical test, value if true, value if false)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Perfect THANKS