# Value formula

C

Colin2u

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

Dave Peterson

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.)
 
D

Dodo

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?
Click to expand...

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