SOLVED

Minimum value in a cell

Copper Contributor

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? 

2 Replies
best response confirmed by knudsen365 (Copper Contributor)
Solution

@knudsen365 

Use

 

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

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!
1 best response

Accepted Solutions
best response confirmed by knudsen365 (Copper Contributor)
Solution

@knudsen365 

Use

 

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

View solution in original post