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
raceproretiredAsked:
Who is Participating?
 
Rgonzo1971Connect With a Mentor Commented:
then try
=IF(AND(H13>0,E$3>D$3),ROUNDUP((H13+(SQRT(E11-D11)))/5,0)*5,ROUNDUP((H13+D$3)/5,0)*5)

Open in new window

1
 
Rgonzo1971Commented:
Hi,

pls try
=IF(AND(H13>0,E$3>D$3),H13+ROUNDUP(((SQRT(E11-D11))/5),0)*5)

Open in new window

Regards
2
 
raceproretiredAuthor Commented:
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
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
Rgonzo1971Commented:
then try for B5

=IF(AND(H5>0,E$3>D$3),ROUNDUP(((H5+SQRT(E3-D3))/5),0)*5)
1
 
raceproretiredAuthor Commented:
The else part is missing   (H5+D$3*0.0025)/2) also needs rounding
0
 
raceproretiredAuthor Commented:
Perfect
Thanks Rgonzo :)
0
 
raceproretiredAuthor Commented:
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
0
 
raceproretiredAuthor Commented:
or 30 rounded up
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.