Link to home
Start Free TrialLog in
Avatar of Starquest321
Starquest321

asked on

Excel Formula

I have a column with a number: 459.
I need to do the following:

Calculate the price based on the following: For the first 100 units multiply by number in column x :: And the rest by column Y

For example:

459   Total price (10*100 ) + (7*359)

COLUMNS
Total :: Price for 100 :: Price for rest
459 :: 10 :: 7
SOLUTION
Avatar of Flyster
Flyster
Flag of United States of America 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
SOLUTION
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
ASKER CERTIFIED SOLUTION
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