• 461K Members
• 5,639 Online
• 559K Conversations
SOLVED

New Contributor

# Help I want the result of a formula to have a minimum value

I'm preparing a spreadsheet with some formulas where it calculates a cost to charge a customer.

 Units of Calculated Cost Amount to be Charged (Min £200) 4 £230 FALSE

The formula in 'Calculated Cost' currently read as follows; =SUM(A2*50)+30   This works perfectly as required. (£30 is an admin fee).

What I want to be able to do is to either modify this formula so that if the 'Units of' was for example 3, the result would be £180 but I want the amount to be charged to be £200 (as a minimum charge.

Ideally, in this scenario, £200 would automatically appear although as you'll see, I'd be happy to have the 'Amount to be Charged (Min £200)' in another cell.

Anybody know the exact formula to get this desired result?

Paul

3 Replies
Solution

# Re: Help I want the result of a formula to have a minimum value

Try this formula in B2:

=MAX(A2*50+30,200)

# Re: Help I want the result of a formula to have a minimum value

Fantastic, thank you so much!

# Re: Help I want the result of a formula to have a minimum value

The pleasure mine!

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies