Forum Discussion

Copper Contributor

Jan 20, 2022

Solved

Minimum value in a cell

I have a cell with this calculation =C13*($D$6*2), however the cell´s value cant be less than 28, I just can´t figure out how to do that. Can anyone help?

excel

HansVogelaar
Jan 20, 2022
knudsen365

Use

=MAX(C13*$D$6*2,28)

2 Replies

HansVogelaar
MVP
Jan 20, 2022
knudsen365

Use

=MAX(C13*$D$6*2,28)
- knudsen365
  Copper Contributor
  Jan 20, 2022
  Thank you so much Hans, i to chance the komma so it went like "=MAX(C13*$D$6*2;28)", but it worked. Thank you!