[SOLVED]If/then range formula help

**DonkeyOte** · 08-07-2009, 03:10 AM

Perhaps:

F21: =B21*CEILING(C2/C21,1)

**rbigrob517** · 08-07-2009, 10:41 AM

Thanks for the help Ya'll. The Ceiling formula worked great. Still very new to excell and had never seen the Ceilling command until now. Thanks again ya'll.

**DonkeyOte** · 08-07-2009, 10:42 AM

Given you're always rounding up to nearest whole number you could use ROUNDUP(C2/C21,0) as opposed to CEILING if preferred (ie if it makes more sense should you come back to review).