Formula calculating % within a cap on amount. Please help this novice!

mmd (Megan) September 14, 2022, 12:13am 1

Struggling with a formula to generate 15% of a quantity but cap it at 150 with no decimals.

Topic		Replies	Views
Formula Column calculate and display percentages Feature requests columns , formula	3	11069	May 25, 2022
Issue - Formula Column does not recognise percentages Platform discussions columns , formula , question	3	566	May 24, 2023
Formula for Calculating Lost Amount Past a Certain Percentage Special workflows & use cases formula	1	719	May 12, 2023
Creating a Percentage Formula with correct decimals points Special workflows & use cases columns , formula	2	1160	January 31, 2023
IF Formula - If Qty equals "0" I would like to output "0" in a specific column, and if not, I would like to perform a formula Special workflows & use cases formula	5	1830	August 2, 2022

Can't find what you're looking for?