Forum Discussion

Paulus100's avatar
Paulus100
Copper Contributor
Oct 10, 2019
Solved

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 ...
  • Twifoo's avatar
    Oct 10, 2019

    Paulus100 

    Try this formula in B2: 

    =MAX(A2*50+30,200)

Resources