n00b question
Posted: 08 September 2004 05:29 AM     [ Ignore ]  
Board Mentor
Total Posts:  3596
Joined  2004-12-22

[edit]for get that—try this:[/edit]

=round(sum(b10:b12),0)

Profile
 
Posted: 08 September 2004 05:29 AM   [ # 1 ]     [ Ignore ]   [ # 1 ]  
Board Mentor
Total Posts:  3596
Joined  2004-12-22

hey, I don’t use excel all that often, but i’m making a spreadhseet for this simple accounting project. I was wondering how i would input a formula AND make it round to the nearest whole number. i know how both functions, but i don’t remember how to use both of them together. i’m just adding two numbers together then rounding it, so it’d be something like =SUM(B12:B10), and the round function is =ROUND(B13,0), but I dunno how to plop those two formulas into the same box.

Profile
 
Posted: 08 September 2004 07:24 AM   [ # 2 ]     [ Ignore ]   [ # 2 ]  
Board Mentor
Total Posts:  3596
Joined  2004-12-22

awesome, it worked. i guess i could of figured that out on my own, i’m an idiot. thanks for the help though. :D

Profile
 
Posted: 08 September 2004 07:34 AM   [ # 3 ]     [ Ignore ]   [ # 3 ]  
Board Mentor
Total Posts:  2597
Joined  2005-01-06

yeah,  I’m the sh*t 😉

Seriously tho, glad it worked for ya.

 Signature 

http://www.pacats.com

Profile