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(k40, 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

scott Wrote:
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(k40,
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(K40,K4,B29))

Regards.


--
BenjieLop


------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019
View this thread: http://www.excelforum.com/showthread...hreadid=496162