Formula to reflect a certain amount in another column

[tgill]

Basically, i am trying to create a formula to say that in Column A every "100" reflects "1"
in column B.

So if A=300 then B=3

i have tried

=IF(INT(A1/100)<1

[protonLeah]

That formula is incomplete why the IF?) and we have no idea where you are putting it (B3, perhaps?):
B3: =INT(A1/100)

[leelnich]

Hi tgill- How about:
=IF(A1<100,"",INT(A1/100))

Please click the Add Reputation star below any helpful posts, and use Thread Tools (up top) to mark your thread as SOLVED once you have your answer. Thanks!-Lee

[tgill]

That formula does work good. Does anyone know how to make these into fractions/decimals? so basically if "A" goes over 100... lets say 150... it will reflect more than 1? 1.5? This formula will only work to 100 at a time. so i will still need more than 1 if it is over the 100 even if it doesn't reach the 200 mark

[leelnich]

Just =A/100, if you want to use interval = 1. If some other interval, for example 50, then this:
=FLOOR(A1, 50)/100

...would yield {0, .5, 1, 1.5, 2, 2.5...}

Please click the Add Reputation star below any helpful posts, and use Thread Tools (up top) to mark your thread as SOLVED once you have your answer. Thanks!-Lee