Condition formula?, displaying 1 for every 25?

[pabraya]

Hello,
This is most likely a very simple question.
What I am trying to do is have a cell add 1 to every 25 in another cell. What I mean is this:
Suppose is cell F12 I put in the number 25, I would then like cell E15 to display 1.
I then insert the number 50 in cell F12; cell E15 would then automatically display the number 2.
I then insert the number 75 in cell F12; cell E15 would then automatically display the number 3.
And so on. I hope this makes sense.


Thanks a Million
pabraya

 

[Aladin Akyurek]

On 2002-08-23 09:26, pabraya wrote:
Hello,
This is most likely a very simple question.
What I am trying to do is have a cell add 1 to every 25 in another cell. What I mean is this:
Suppose is cell F12 I put in the number 25, I would then like cell E15 to display 1.
I then insert the number 50 in cell F12; cell E15 would then automatically display the number 2.
I then insert the number 75 in cell F12; cell E15 would then automatically display the number 3.
And so on. I hope this makes sense.


Thanks a Million
pabraya

Perhaps

=F12/25

to be entered in E15 ?

 

[lenze]

In E15 enter
=F12/25

You might use =ROUND(F12/15,0) or perhaps

=FLOOR(F12/25,1)

 

[pabraya]

That was it! Thanks a Million Aladin Akyurek


Pabraya