If Formula ignoring 0, help???

[stephen.smith]

Hi Guys
I have a database that I am using an If formula to determine a result however some cells that have a zero value are throwing my results. Can anyone help please. This is the formula I am using =IF((F4<F$44),"STRESS","OK")
Thanks In Advance

 

[Scott Huish]

Here's your complete formula:

=IF((F4 < F$44),"STRESS","OK")

What cell contains the 0 that is throwing your results, and what do you want it to do in that case?

 

[stephen.smith]

F4 is the one causing the problem

 

[barry houdini]

So what's wrong? F4 is zero, what's F44 and what result do get/what do you expect?

 

[stephen.smith]

F4 can have any number from 0 to 50 depending on a result from a questionnaire staff fill out however if the question is irrelevant on a given week the question is ignored and the cell then reads 0. I have 42 staff members each with their own cell for this particular answer and f44 refers to the group average and what I want to find out is which answers are below average but my results keep being thrown by cells which have no value and are irrelevant.

 

[barry houdini]

If you change the formula to this then you'll just get a blank when F4 = 0

=IF(F4=0,"",IF(F4< F$44,"STRESS","OK"))