User Profile
Gilbert1240
Copper Contributor
Joined Mar 19, 2023
User Widgets
Recent Discussions
Re: VBA Run-time error '1004' when Hide/Show Rows
I managed to produce a formula in excel through the online excel tutorial, covering two of the three conditions. II miss now if the calculation is correct. I have now if the result of the calculation is >40 the result becomes 40, and if the result of the calculation is <0 (negative) the result becomes 0. the formula I made is as follows: =IF (180-G6/i6>40,"40",IF(180-G6/I6<0,"0")) Please Help3.1KViews0likes2Comments
Recent Blog Articles
No content to show