hi,
just curious about this one,
A1 : target number
B1 : any number
C1 : formula to get (target number / any number) with the result closest to the target number
example A1 : 30, B1: 9, C1 = 3
thanks
hi,
just curious about this one,
A1 : target number
B1 : any number
C1 : formula to get (target number / any number) with the result closest to the target number
example A1 : 30, B1: 9, C1 = 3
thanks
Last edited by koi; 12-22-2012 at 12:58 PM.
hi koi, you mean like a round down? in C1
=FLOOR(A1/A2,1)
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
You could try: =ROUND(A1/B1,0)
- Moo
thanks guys, awesome solution
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks