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

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

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.