This formula is good by itself as a dimension calculator
1.17 * sqrt(Designed Air Flow / 1.75 m/s)
but when I do this
round(1.17 * sqrt(Designed Air Flow / 1.75 m/s))
I get inconsistent units error!!
any thoughts?
Regards,
M
Solved! Go to Solution.
Solved by CoreyDaun. Go to Solution.
The ROUND functions only work with unitless Number values, so you cannot directly round Air Velocity, Angle, or Length Parameters to name a few. The trick here is to strip the units before the ROUND function and then reapply the units at the end of the formula. Silly, I know...
= round((1.17 Hz * sqrt(Designed Air Flow / 1.75 m/s)) / 1 m/s) * 1 m/s
A simpler example of this would be:
= round(Length / 2) (yields an error)
becomes
= round((Length / 2) / 1 mm) * 1 mm
(or you could just add the units to the "/2")
= round(Length / 2 mm) * 1 mm
Can't find what you're looking for? Ask the community or share your knowledge.