Help! How do I stop getting an error if my Round up formula is 0

[RuthQ]

Hi,

I’m trying to do a simple formula however if the Est Number of hours column is 0 I get an error. I’ve tried a few things but nothing works, any ideas where I’m going wrong?

ROUND({EST Number of hours}/{Budget estimator}*100,1)&"%"

Thanks,
Ruth

[JCorrell]

@RuthQ

I suspect that the problem is actually when {Budget estimator} is zero… this will create a divide by zero situation. Give this a try: (I tested it. )

IF({Budget estimator}+0, ROUND({Est Number of hours} / IF({Budget estimator}+0, {Budget estimator}, 1) * 100, 1) & "%", "")

Jim - The Monday Man (YouTube Channel)
Watch Our Latest Video: Column Total in monday.com Formulas? YES!!!
Check out our monday apps, now in beta: The Monday Man Apps

[RuthQ]

@JCorrell

IF({Budget estimator}+0, ROUND({Est Number of hours} / IF({Budget estimator}+0, {Budget estimator}, 1) * 100, 1) & "%", "")

Amazing, thanks so much, thats worked