Ian Bell
asked on
correct sqrt formula and roundup
Hi,
I would like a correction to attached formula and roundup to nearest 5
Please refer to sheet
many thanks
Ian
ROUNDUP.xlsx
I would like a correction to attached formula and roundup to nearest 5
Please refer to sheet
many thanks
Ian
ROUNDUP.xlsx
ASKER
Hi Rgonzo,
Actually, I was ideally wanting the formula supplied in either cell B5 or B13 to be modified
as there are other criteria like adding H5 or H13.
Thanks
Actually, I was ideally wanting the formula supplied in either cell B5 or B13 to be modified
as there are other criteria like adding H5 or H13.
Thanks
then try for B5
=IF(AND(H5>0,E$3>D$3),ROUNDUP(((H5+SQRT(E3-D3))/5),0)*5)
=IF(AND(H5>0,E$3>D$3),ROUNDUP(((H5+SQRT(E3-D3))/5),0)*5)
ASKER
The else part is missing (H5+D$3*0.0025)/2) also needs rounding
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Perfect
Thanks Rgonzo :)
Thanks Rgonzo :)
ASKER
OOPS sorry I didn't check the else. It produced a value of 5020 instead of H6+E$3*.0025 which should equal 27.5
Thanks if you don't mind correcting.
Ian
Thanks if you don't mind correcting.
Ian
ASKER
or 30 rounded up
pls try
Open in new window
Regards