Aug 13, 2010 #1 Chris559 Instructor Joined Dec 29, 2002 Messages 30 Location GB If I have a cell that has a SUM formula, can I also use ROUNDDOWN as well?
Aug 13, 2010 1 #2 lionelhill Technical User Joined Dec 14, 2002 Messages 1,520 Location GB you can nest formulae as far as you want =rounddown(sum(A1:A20), 2) Upvote 0 Downvote
Aug 13, 2010 Thread starter #3 Chris559 Instructor Joined Dec 29, 2002 Messages 30 Location GB Thanks for this - now working well!! Upvote 0 Downvote
Aug 14, 2010 #4 S SkipVought Programmer Joined Dec 4, 2001 Messages 47,492 Location US FYI, you have ONE formula, using two functions. Skip, Just traded in my old subtlety... for a NUANCE! Upvote 0 Downvote
FYI, you have ONE formula, using two functions. Skip, Just traded in my old subtlety... for a NUANCE!