User Profile
Guavapip
Copper Contributor
Joined 2 years ago
User Widgets
Recent Discussions
Re: I need help please with this formula
BIGGEST THANKS Riny_van_Eekelen for your help ... in the end I could not get it to work ... so I broke up the formula and then worked it out seperately ... but again, BIggest thanks for your time and help ... nice to have someone out there for help 🙂1KViews0likes0CommentsI need help please with this formula
=IF(Y<=$AF$1,SUM(S14*ROUNDUP(SUM(ROUNDDOWN(200/R14,0)/ROUNDDOWN(150/T14,0)),IF(SUM(S14*ROUNDUP(ROUNDDOWN(200/R14,0)/ROUNDDOWN(150/T14,0))<=75,"HiDens","FALSE")) Basically if y <= .00225 then calculate the sum of s * roundedup of sum of (rounddown (200/r,0)/rounddown (150/t,0)), then if all of this is <= 75 write "HiDens' in Excel can anyone help ... my formula keeps returning #NAME?Solved1.1KViews0likes2Comments
Groups
Recent Blog Articles
No content to show