troubleshooting Question

Excel Formula

Avatar of Starquest321
Starquest321 asked on
Microsoft ExcelSpreadsheets
3 Comments3 Solutions291 ViewsLast Modified:
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)

Total :: Price for 100 :: Price for rest
459 :: 10 :: 7
Join our community to see this answer!
Unlock 3 Answers and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros