I bet you typed in the wrong formula in the post.

But check each of those cells to see if they are all numeric. (if you have text
in H47, then H47+I47 would cause that error.)

Colin2u wrote:

I have a formula thats keeps giving me this return: in cell
J47=if(I47<25,H47<if(I47=25,H47+I47))
Is ther a way to prevent this?

--

Dave Peterson