IF Formula Tweak

[CherryxDarling]

I have this formula:

=IF(E57="","",IF(E57>=16,ROUNDUP(E57/100,0),0))

which calculates how many drinking fountains are needed per 100 people. I didn't notice that there was a little subnote to this which states that drinking fountains are not required for for 15 people or less.

So my question is how do I add that to this formula? I need to make it so that when I insert a value that is 15 or less, it will give me a 0.

 

[VoG]

It already does that with the parts in red

=IF(E57="","",IF(E57>=16,ROUNDUP(E57/100,0),0))

 

[CherryxDarling]

It already does that with the parts in red

=IF(E57="","",IF(E57>=16,ROUNDUP(E57/100,0),0))

LOL oh my god! I'm sorry it's Friday... I forgot I already tweaked it so nevermind!!