# Value formula

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?

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

"=?Utf-8?B?Q29saW4ydQ==?=" <[email protected]> wrote in
news:[email protected]:

> 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?

Is it a typo?

=if(I47<25,H47,if(I47>=25,H47+I47))

This does the same:

=if(I47<25,H47,H47+I47)

Looks better that way. Or do I miss something?


--

It is I, DeauDeau
(Free after monsieur Leclerc in 'Allo, 'allo)