Help with formula whole numbers divided

[panorama]

Hi, first post....

I have a chart that starts at (which has been worked out manually)
$0.01 to $122.14 =1 UNIT
$122.15 to $244.28 =2 UNITS
$244.29 to $366.42 =3 UNITS

and so on this is based on a Unit whose value is $122.14.

I want to create a spreadsheet where the user inputs a dollar amount and the result is displayed for the correct amount of units.

so if I divide the unit $122.14 into say the first row .05 cents I get a result of .0004093.
I want it to be a whole number 1 UNIT if the user inputs .05.

Any idea how to do this???????

Thanks
Stephen

 

[T. Valko]

Why not save Excel the trouble of calculating that first condition...

=IF(A1>12214,"Max Units Allowed",CEILING(A1/122.14,1))

Yeah, good point!

 

[T. Valko]

WOW, thanks for the quick response........... works great.

PS Somesh yours works as well but I would have too many cells

Try Rick's suggestion. It's more succinct.

 

[panorama]

Thanks, everyone for a wonderful selection of replys to my original question and yes I have gone with Rick's.

Thanks again

 

[T. Valko]

Thanks, everyone for a wonderful selection of replys to my original question and yes I have gone with Rick's.

Thanks again

Good deal. Thanks for the feedback!