Excel Cell Min and Max Limits

[graham.jenks]

Hi, was wondering if someone could give me some guidance. I work in Insurance and have a spreadsheet which requires [oil] values to be entered into Column J. I then have three additional columns (K,L & M) and I require them to do the following:

K: take the value from J but cap it at $100,000,000.
L: take the value from J but have a minimum value of $100,000,000 and a maximum value of $400,000,000.
M: take the value from J but have a minimum value of $500,000,000 and a maximum value of $100,000,000.

For example, if i were to enter a value of $650,000,000 into Column J, Column K should show $100,000,000, Column L should show $400,000,000 and Column M should show $50,000,000. Likewise if I were enter $15,000,000 into Column J, Column K would show $15,000,000, Column L would show $- and Column M would show $-.

Any help would be greatly appreciated. Thank you.