add 1 to a cell when a another cells reaches a certain value

[shilpz]

hello ppl

i wanted to know if there is a formular that would say if a certain cell reaches a certain value it will add 1 to another cell for example

if cell B2 reaches 24 then 1 would be added to cell B3

thanks in advance

[oldchippy]

Hi,

Not sure if you want 1 to be in B3, or 1 to be added to the value in B3.

First

=IF(B2>=24,1,"")

Second

=IF(B2>=24,B3+1,"")

[shilpz]

hello
thanks for the reply
dat formular only adds 1 when da cells goes to 24 but when it goes back down it becomes blank
i want the formula to keep on adding 1 everytime it reaches 24

for example

if you have a table and you wants Cell b15 to add 1 on to B15 everytime cell B14 reaches 24
eg B14 would reset when it goes to 24

[oldchippy]

You need some VBA code to do that, I'm afraid thats not my expertise. Maybe someone out there can help our friend here - ANYONE THERE!

[shilpz]

Thanks for your help tho still reali apraciate it

is there any1 thats noes a VBA code??????

[VBA Noob]

Can you explain a bit more.

Is B14 a formula ??

eg B14 would reset when it goes to 24

How

VBA Noob

[shilpz]

noo its not a code
just a example
in short
everytime you type 24 in say B12 then it would add 1 to B13

[VBA Noob]

Right click your sheet tab > select view code > paste in the below

When B12 is > = 24 then B13 will increase by 1

Please Login or Register  to view this content.

HTH

VBA Noob

[shilpz]

omg it works
thanks alot you dont know how much this has helped me
thanks a alot bro

[VBA Noob]

Your welcome


VBA Noob

[shilpz]

sorry another problem

u no da code u gave me it works and all
but on that cell i got a sum forumalr adding range F8:F14
so if i put da forumlar the forumla deletes
isent there a way i can keep that same function but i need to sum foumalar to stay
if u get what i mean

[VBA Noob]

See if this helps

If Range F8 to F14 total is 12 and you enter a number in B12 >=24 then B13 will equal value of B13 (12) + 1 + sum total 12 = 25

Please Login or Register  to view this content.

VBA Noob

[shilpz]

thanks for your help

i have attached a file which explains the problem that i am facing if you could please help me solve it i would be real grateful
that in advance

[VBA Noob]

Format cell as

[h]:mm

which goes over 24 hrs

VBA Noob

[shilpz]

now the proble is that because i formated the cell as "[h]:mm" i cannot times that by a number to find out the wage e.g.

Cell F15 has the time worked for the week formated as "[h]:mm" but in cell G15 i have put a formula "=F15*6" 6 being the hourly rate but that dont work

F15 has 36:00 and that multiplied by 6 should equal to 216 but the answer gives me ZERO

thanks in advance

[VBA Noob]

See if attached helps

VBA Noob

[shilpz]

Thanks alot bro
u helped me bareeee
i was stuck on this problem for bareee time
i thought i had to change da code and this and that, but it was so simple
Thanks alot
reli appreciate it
thanks again