Simple question

Feb 20th, 2002, 08:04 PM

cell c1 is the sum of a1 & b1. I need to round c1, but the value varies depending on a1 & b1's values. How do I do this?

RichardS · Feb 20th, 2002, 08:20 PM

Don't quite understand. Do you mean the way the rounding is done is determined ny the values in A & B? If so, can you give an example of what you mean.
Richard

anno · Feb 20th, 2002, 08:21 PM

i think the answer will depend on how many variations there are. can you prvide more detail?

Feb 21st, 2002, 05:42 AM

Say for instance...

in one case the values of A1 & B1 might be:
A1=8.67
B1=1.33
C1=A1/B1 (6.518...), but I need this to be a whole number, or 7

in another case, the values of A1 & B1 might be:

A1=12.33
B2=1.08
C1=A1/B1 (11.416...), but it too will need to be a whole number, or 11.

In all cases, C1 needs to be a whole number, being rounded down if it's __.49 or less, or rounded up if it's __.50 or more.

Any ideas??

Derek · Feb 21st, 2002, 06:14 AM

Hi
Just use =Round(A1/B1,0)
This should round up or down to the nearest integer
Derek

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 20th, 2002, 08:04 PM	#1
Guest Posts: n/a	cell c1 is the sum of a1 & b1. I need to round c1, but the value varies depending on a1 & b1's values. How do I do this?

Feb 20th, 2002, 08:20 PM	#2
RichardS Board Regular Join Date: Feb 2002 Location: Victoria, Australia Posts: 761	Don't quite understand. Do you mean the way the rounding is done is determined ny the values in A & B? If so, can you give an example of what you mean. Richard

Feb 20th, 2002, 08:21 PM	#3
anno Board Regular Join Date: Feb 2002 Posts: 202	i think the answer will depend on how many variations there are. can you prvide more detail?

Feb 21st, 2002, 05:42 AM	#4
Guest Posts: n/a	Say for instance... in one case the values of A1 & B1 might be: A1=8.67 B1=1.33 C1=A1/B1 (6.518...), but I need this to be a whole number, or 7 in another case, the values of A1 & B1 might be: A1=12.33 B2=1.08 C1=A1/B1 (11.416...), but it too will need to be a whole number, or 11. In all cases, C1 needs to be a whole number, being rounded down if it's __.49 or less, or rounded up if it's __.50 or more. Any ideas??

Feb 21st, 2002, 06:14 AM	#5
Derek Board Regular Join Date: Feb 2002 Location: Perth Australia Posts: 1,567	Hi Just use =Round(A1/B1,0) This should round up or down to the nearest integer Derek