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)

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!