How to insert a helper?

[sovietchild]

Hello I use this code: =MIN(B8,1) as a helper, so, whatever goes over 100% stops at 100%, however right now I have -20% how to stop it at 0? So, whatever goes below 0% stops at 0%.

Template attached.

[FDibbins]

Try this...
=MAX(0,MIN(B21,1))

[sovietchild]

Try this...
=MAX(0,MIN(B21,1))

Awesome! Thanks!

[FDibbins]

Awesome! Thanks!

happy to help

[sovietchild]

Try this...
=MAX(0,MIN(B21,1))

Thanks again!

thanks.png

[XL&ME]

Very nice looking dashboard. If possible, could you post your workbook for the dashboard. Delete all sensitive information.

Thanks

[sovietchild]

Very nice looking dashboard. If possible, could you post your workbook for the dashboard. Delete all sensitive information.

Thanks

Sure, I'll upload it tomorrow.

[sandy666]

try =MIN(B21,0)

[sovietchild]

Here it is https://www.excelforum.com/tips-and-...ml#post4628975

[FDibbins]

Thats for the upload, it looks REALLY good, well done!!
(and thanks for thanking the members here, always appreciated)