RuthQ
(Ruth)
February 9, 2022, 10:39am
1
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
(Jim - The Monday Man)
February 9, 2022, 11:39am
2
@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
(Ruth)
February 9, 2022, 11:44am
3
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
system
(system)
Closed
February 16, 2022, 11:45am
4
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.