IF Formula Help

[CherryxDarling]

I absolutely suck at formulas and really need some help here.

Ok so I have this formula: =IF(E7="","",IF(E7>=125,ROUNDUP((E7/2)/125,0),1))

which I use to calculate how many toilets are needed per 125 people.

Now I need to just take 67% of the answer this formula gives me. I know it seems like a simple question, but I tried like a thousand different ways to do it and it was giving me funky answers.

I still want the formula to round up and all the other good stuff that's in the formula already, but I just need it to be multiplied by 67% after I get the answer.

 

[lenze]

=(IF(E7="","",IF(E7>=125,ROUNDUP((E7/2)/125,0),1)))*0.67

lenze

 

[CherryxDarling]

=(IF(E7="","",IF(E7>=125,ROUNDUP((E7/2)/125,0),1)))*0.67

lenze

When I entered the formula it gave me #VALUE

 

[lenze]

Try this

=IF(E7,IF(E7>=125,ROUNDUP((E7/2)/125,0),1))*0.67

lenze

 

[CherryxDarling]

=(IF(E7="","",IF(E7>=125,ROUNDUP((E7/2)/125,0),1)))*0.67

lenze

http://www.flickr.com/photos/63155168@N08/5736783545/in/photostream

Here is what I'm trying to do...
I want the new formula to be in H7 under "Urnial Substitution"

 

[CherryxDarling]

Try this

=IF(E7,IF(E7>=125,ROUNDUP((E7/2)/125,0),1))*0.67

lenze

Sorry this didn't work either

 

[CherryxDarling]

I still need to the formula to round the answer up.

 

[lenze]

=ROUNDUP(IF(E7,IF(E7>=125,ROUNDUP((E7/2)/125,0),1))*0.67,0)

or

=ROUNDUP(IF(E7,IF(E7>=125,(E7/2)/125),1)*0.67,0)

lenze