Excel Formula Question

[sublime1184]

I have this formula in cell C9:

=0.5*$H$1 &" serving(s)"

It's equal to the number of children in the day care ($H$1) times the amount of minimum serving per child (.5) in ounces. So my result looks like this:

"7.5 serving(s)" - (15 children in room 1). Anyway, my questions is is there a circular reference or any formula that I can use to make that cell round up to 8? I'd like it to round up to 8 if it is over 7.0...

Formatting won't do it and I've used the =ROUNDUP(C9,0) formula...

TIA!

 

[budrecki]

You cannot grow children with excel.....unless you increase the dlpp (daylight per pound)

How many times must I tell these people!!!

 

[dougall]

I'm totally too lazy to fire up a windows machine to look at Excel right now.

But wouldn't something like

=int(0.5+0.5*$H$1) &" serving(s)"

do what you want?

 

[sublime1184]

ok, I figured it out. It camed to me while i was playing Halo 2 over LAN ...Similar to yours doug, but I had ", 0" (note the space) when I shouldn't have. It should have worked, space or no space, but it wasn't...

And for anyone interested, here is the code:

=ROUNDUP(0.5*$H$1,0) &" serving(s)"

 

[dougall]

just go back to drinking..

I did actually check mine and it worked.. I just didnt have a formula reference handy so used something I knew would work..

 

[sublime1184]

Thx for the help doug! :sim:

 

[dougall]

help??

I just told you to go back to drinking..


I'm heeding my own advice too.