Help with formula IF

[scott]

I have a column that has a simple IF formula. What has happened is this
formual is not working how I need it to. At the end of a day we need to know
how many hours this setting was used. If no number is entered into the cell I
have my If formula showing ther plant hours run for the day. if(k4>0, k4,
b29).
K4 is the hours run
b29 is total hours
so if k4 is >0 show k4, otherwise show b29
The problem is that if the settings are changed at plant start up my k4
hours run should read 0 but with the formual I have it shows b29 which would
be total hours ran. When no settings are changed I need this hours run to
read the plant hours. I hope this is not to confusing. Any help is
appreciated.

In this case when the plant is started up and settings are changed I would
need k4 to read zero. I have also tried if(k4>=0, k4, b29). With this formula
when k4 is left blank I need b29(plant hours) but it shows 0
What I need when I put a zero in k4 I need it to show zero.
Thanks in advance

Scott

[BenjieLop]

I have a column that has a simple IF formula. What has happened is this
formual is not working how I need it to. At the end of a day we need to know
how many hours this setting was used. If no number is entered into the cell I
have my If formula showing ther plant hours run for the day. if(k4>0, k4,
b29).
K4 is the hours run
b29 is total hours
so if k4 is >0 show k4, otherwise show b29
The problem is that if the settings are changed at plant start up my k4
hours run should read 0 but with the formual I have it shows b29 which would
be total hours ran. When no settings are changed I need this hours run to
read the plant hours. I hope this is not to confusing. Any help is
appreciated.

In this case when the plant is started up and settings are changed I would
need k4 to read zero. I have also tried if(k4>=0, k4, b29). With this formula
when k4 is left blank I need b29(plant hours) but it shows 0
What I need when I put a zero in k4 I need it to show zero.
Thanks in advance

Scott

Try this formula and see if this is what you need ...

=IF(K4=0,0,IF(K4>0,K4,B29))

Regards.